Hi guys,

Is there any limitation in Trigger function??

I keep getting this error message "[Pervasive][ODBC Client
Interface][LNA][Pervasive][ODBC Engine Interface][Data Record
Manager]The record has a key field containing a duplicate value(Btrieve
Error 5)" What does this mean??

Can someone help me out this please?

CREATE TRIGGER InsInvTrig
AFTER INSERT ON INVFULL
REFERENCING NEW AS Indata

FOR EACH ROW
INSERT INTO tempINVFULL (I_FULL_KEY, I_WHSE, I_PART_NO, I_DESCRIPTION,
I_PROD_CODE, I_LOCATION, I_BVRESERVED01, I_MEASURE, I_COST_CURRENT,
I_COST_AVERAGE, I_SELL_PRICE01, I_SELL_PRICE02, I_SELL_PRICE03,
I_SELL_PRICE04, I_SELL_PRICE05, I_SELL_PRICE06, I_SELL_PRICE07,
I_SELL_PRICE08, I_SELL_PRICE09, I_SELL_PRICE10, I_SELL_PRICE11,
I_SELL_PRICE12, I_SELL_PRICE13, I_SELL_PRICE14, I_SELL_PRICE15,
I_SELL_PRICE16, I_SELL_PRICE17, I_SELL_PRICE18, I_SELL_PRICE19,
I_SELL_PRICE20, I_E_SPECIAL_START, I_E_SPECIAL_END, I_E_ON_SPECIAL,
I_E_SPECIAL_PRICE, I_QTYBREAK_QTY1, I_QTYBREAK_QTY2, I_QTYBREAK_QTY3,
I_QTYBREAK_QTY4, I_QTYBREAK_QTY5, I_QTYBREAK_QTY6, I_QTYBREAK_QTY7,
I_QTYBREAK_QTY8, I_QTYBREAK_QTY9, I_QTYBREAK_PRICE1, I_QTYBREAK_PRICE2,
I_QTYBREAK_PRICE3, I_QTYBREAK_PRICE4, I_QTYBREAK_PRICE5,
I_QTYBREAK_PRICE6, I_QTYBREAK_PRICE7, I_QTYBREAK_PRICE8,
I_QTYBREAK_PRICE9, I_TAX01_FLAG, I_TAX02_FLAG, I_CURRENT_PO_NO,
I_BVRESERVED06, I_BVRESERVED07, I_PO_DUE_DATE, I_BVRESERVED08,
I_DISCOUNTABLE, I_SERIALIZED_FLAG, I_NOTEPAD_FLAG, I_SUPP_NO1,
I_SUPP_NO2, I_SUPP_NO3, I_SUPP_NO4, I_SUPP_NO5, I_SUPP_PART1,
I_SUPP_PART2, I_SUPP_PART3, I_SUPP_PART4, I_SUPP_PART5, I_SUPP_COST1,
I_SUPP_COST2, I_SUPP_COST3, I_SUPP_COST4, I_SUPP_COST5, I_LEAD_DAYS,
I_SALES_DEPT, I_BVRESERVED09, I_BVRESERVED10, I_ONHAND_QTY, I_ROP_QTY,
I_COMMITTED_QTY, I_BACKORDER_QTY, I_ON_PURCHASE_QTY, I_BVRESERVED11,
I_ALT_PART, I_BVRESERVED99, I_BVRESERVED12, I_USER_DEF1, I_USER_DEF2,
I_BVRESERVED22, I_SALES_UNITS01, I_BVRESERVED23, I_SALES_UNITS02,
I_SALES_UNITS03, I_BVRESERVED24, I_BVRESERVED25, I_SALES_UNITS04,
I_BVRESERVED26, I_SALES_UNITS05, I_BVRESERVED27, I_SALES_UNITS06,
I_BVRESERVED28, I_SALES_UNITS07, I_SALES_UNITS08, I_BVRESERVED29,
I_BVRESERVED30, I_SALES_UNITS09, I_BVRESERVED31, I_SALES_UNITS10,
I_SALES_UNITS11, I_BVRESERVED32, I_BVRESERVED33, I_SALES_UNITS12,
I_SALES_YR_FLAG01, I_SALES_YR_FLAG02, I_SALES_YR_FLAG03,
I_SALES_YR_FLAG04, I_SALES_YR_FLAG05, I_SALES_YR_FLAG06,
I_SALES_YR_FLAG07, I_SALES_YR_FLAG08, I_SALES_YR_FLAG09,
I_SALES_YR_FLAG10, I_SALES_YR_FLAG11, I_SALES_YR_FLAG12, I_TYPE_KEY,
I_TYPE, I_DESC_KEY, I_BVRESERVED13, I_WEIGHT, I_BVRESERVED14,
I_CONNECT1, I_CONNECT2, I_CONNECT3, I_CONNECT4, I_CONNECT5, I_CONNECT6,
I_CONNECT7, I_BVRESERVED15, I_BVRESERVED16, I_BVRESERVED17,
I_BVRESERVED18, I_BVRESERVED19, I_PRICE01_CURR, I_PRICE02_CURR,
I_PRICE03_CURR, I_PRICE04_CURR, I_PRICE05_CURR, I_PRICE06_CURR,
I_PRICE07_CURR, I_PRICE08_CURR, I_PRICE09_CURR, I_PRICE10_CURR,
I_PRICE11_CURR, I_PRICE12_CURR, I_PRICE13_CURR, I_PRICE14_CURR,
I_PRICE15_CURR, I_PRICE16_CURR, I_PRICE17_CURR, I_PRICE18_CURR,
I_PRICE19_CURR, I_PRICE20_CURR, I_E_COMMERCE, I_E_UPLOADED,
I_E_MODIFIED, I_BVRESERVED34, cond)
VALUES (Indata.I_FULL_KEY, Indata.I_WHSE, Indata.I_PART_NO,
Indata.I_DESCRIPTION, Indata.I_PROD_CODE, Indata.I_LOCATION,
Indata.I_BVRESERVED01, Indata.I_MEASURE, Indata.I_COST_CURRENT,
Indata.I_COST_AVERAGE, Indata.I_SELL_PRICE01, Indata.I_SELL_PRICE02,
Indata.I_SELL_PRICE03, Indata.I_SELL_PRICE04, Indata.I_SELL_PRICE05,
Indata.I_SELL_PRICE06, Indata.I_SELL_PRICE07, Indata.I_SELL_PRICE08,
Indata.I_SELL_PRICE09, Indata.I_SELL_PRICE10, Indata.I_SELL_PRICE11,
Indata.I_SELL_PRICE12, Indata.I_SELL_PRICE13, Indata.I_SELL_PRICE14,
Indata.I_SELL_PRICE15, Indata.I_SELL_PRICE16, Indata.I_SELL_PRICE17,
Indata.I_SELL_PRICE18, Indata.I_SELL_PRICE19, Indata.I_SELL_PRICE20,
Indata.I_E_SPECIAL_START, Indata.I_E_SPECIAL_END,
Indata.I_E_ON_SPECIAL, Indata.I_E_SPECIAL_PRICE,
Indata.I_QTYBREAK_QTY1, Indata.I_QTYBREAK_QTY2, Indata.I_QTYBREAK_QTY3,
Indata.I_QTYBREAK_QTY4, Indata.I_QTYBREAK_QTY5, Indata.I_QTYBREAK_QTY6,
Indata.I_QTYBREAK_QTY7, Indata.I_QTYBREAK_QTY8, Indata.I_QTYBREAK_QTY9,
Indata.I_QTYBREAK_PRICE1, Indata.I_QTYBREAK_PRICE2,
Indata.I_QTYBREAK_PRICE3, Indata.I_QTYBREAK_PRICE4,
Indata.I_QTYBREAK_PRICE5, Indata.I_QTYBREAK_PRICE6,
Indata.I_QTYBREAK_PRICE7, Indata.I_QTYBREAK_PRICE8,
Indata.I_QTYBREAK_PRICE9, Indata.I_TAX01_FLAG, Indata.I_TAX02_FLAG,
Indata.I_CURRENT_PO_NO, Indata.I_BVRESERVED06, Indata.I_BVRESERVED07,
Indata.I_PO_DUE_DATE, Indata.I_BVRESERVED08, Indata.I_DISCOUNTABLE,
Indata.I_SERIALIZED_FLAG, Indata.I_NOTEPAD_FLAG, Indata.I_SUPP_NO1,
Indata.I_SUPP_NO2, Indata.I_SUPP_NO3, Indata.I_SUPP_NO4,
Indata.I_SUPP_NO5, Indata.I_SUPP_PART1, Indata.I_SUPP_PART2,
Indata.I_SUPP_PART3, Indata.I_SUPP_PART4, Indata.I_SUPP_PART5,
Indata.I_SUPP_COST1, Indata.I_SUPP_COST2, Indata.I_SUPP_COST3,
Indata.I_SUPP_COST4, Indata.I_SUPP_COST5, Indata.I_LEAD_DAYS,
Indata.I_SALES_DEPT, Indata.I_BVRESERVED09, Indata.I_BVRESERVED10,
Indata.I_ONHAND_QTY, Indata.I_ROP_QTY, Indata.I_COMMITTED_QTY,
Indata.I_BACKORDER_QTY, Indata.I_ON_PURCHASE_QTY,
Indata.I_BVRESERVED11, Indata.I_ALT_PART, Indata.I_BVRESERVED99,
Indata.I_BVRESERVED12, Indata.I_USER_DEF1, Indata.I_USER_DEF2,
Indata.I_BVRESERVED22, Indata.I_SALES_UNITS01, Indata.I_BVRESERVED23,
Indata.I_SALES_UNITS02, Indata.I_SALES_UNITS03, Indata.I_BVRESERVED24,
Indata.I_BVRESERVED25, Indata.I_SALES_UNITS04, Indata.I_BVRESERVED26,
Indata.I_SALES_UNITS05, Indata.I_BVRESERVED27, Indata.I_SALES_UNITS06,
Indata.I_BVRESERVED28, Indata.I_SALES_UNITS07, Indata.I_SALES_UNITS08,
Indata.I_BVRESERVED29, Indata.I_BVRESERVED30, Indata.I_SALES_UNITS09,
Indata.I_BVRESERVED31, Indata.I_SALES_UNITS10, Indata.I_SALES_UNITS11,
Indata.I_BVRESERVED32, Indata.I_BVRESERVED33, Indata.I_SALES_UNITS12,
Indata.I_SALES_YR_FLAG01, Indata.I_SALES_YR_FLAG02,
Indata.I_SALES_YR_FLAG03, Indata.I_SALES_YR_FLAG04,
Indata.I_SALES_YR_FLAG05, Indata.I_SALES_YR_FLAG06,
Indata.I_SALES_YR_FLAG07, Indata.I_SALES_YR_FLAG08,
Indata.I_SALES_YR_FLAG09, Indata.I_SALES_YR_FLAG10,
Indata.I_SALES_YR_FLAG11, Indata.I_SALES_YR_FLAG12, Indata.I_TYPE_KEY,
Indata.I_TYPE, Indata.I_DESC_KEY, Indata.I_BVRESERVED13,
Indata.I_WEIGHT, Indata.I_BVRESERVED14, Indata.I_CONNECT1,
Indata.I_CONNECT2, Indata.I_CONNECT3, Indata.I_CONNECT4,
Indata.I_CONNECT5, Indata.I_CONNECT6, Indata.I_CONNECT7,
Indata.I_BVRESERVED15, Indata.I_BVRESERVED16, Indata.I_BVRESERVED17,
Indata.I_BVRESERVED18, Indata.I_BVRESERVED19, Indata.I_PRICE01_CURR,
Indata.I_PRICE02_CURR, Indata.I_PRICE03_CURR, Indata.I_PRICE04_CURR,
Indata.I_PRICE05_CURR, Indata.I_PRICE06_CURR, Indata.I_PRICE07_CURR,
Indata.I_PRICE08_CURR, Indata.I_PRICE09_CURR, Indata.I_PRICE10_CURR,
Indata.I_PRICE11_CURR, Indata.I_PRICE12_CURR, Indata.I_PRICE13_CURR,
Indata.I_PRICE14_CURR, Indata.I_PRICE15_CURR, Indata.I_PRICE16_CURR,
Indata.I_PRICE17_CURR, Indata.I_PRICE18_CURR, Indata.I_PRICE19_CURR,
Indata.I_PRICE20_CURR, Indata.I_E_COMMERCE, Indata.I_E_UPLOADED,
Indata.I_E_MODIFIED, Indata.I_BVRESERVED34, 'I');

See second post.


portCo wrote: