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 Inventory
REFERENCING NEW AS Indata

FOR EACH ROW
INSERT INTO tempInventory (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');

Is the problem with the CREATE TRIGGER statement, or with the firing of
the trigger?

I tested the former, and it works on PSQLV8.7 (Service Pack 3). You
can compare this with your version & see if you need to apply a service
pack or something.

I could not test the latter, of course, without your data files &
dictionaries. However, if the error comes then, it simply means that
the INSERT statement is causing a duplicate value to be inserted on a
UNIQUE key. Check your keys in the tempInventory table & find out
which ones are UNIQUE. If they are UNIQUE by mistake, try removing
them, or remove the UNIQIUE modifier. If they are supposed to be
unique, find out why they are being duplicated.
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Chicago: Pervasive Service & Support Class - 03/27/06 ***

portCo wrote: