f



Urgent: Trigger problem... need help

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');

0
portCo
3/17/2006 9:18:49 PM
comp.databases.btrieve 914 articles. 0 followers. datenisis (11) is leader. Post Follow

1 Replies
705 Views

Similar Articles

[PageSpeed] 12

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@goldstarsoftware.com
	http://www.goldstarsoftware.com
	*** Chicago: Pervasive Service & Support Class - 03/27/06 ***

portCo wrote:

> 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');

0
Bill
3/17/2006 10:48:51 PM
Reply:

Similar Artilces:

need to compute this problem having problems with how to start this problem help need urgently
Let   U[0; 2theta] be a uniform random variable from the interval [0; 2theta] and let A  Exp(1) be exponentially distributed with mean 1. Assume  and A independent. Compute the mean mX(t) =E[X(t)] and autocorrelation RX(s; t) = E[X(s)X(t)] of the phase-shifted sinusoid.X(t) = A*  cos(t +theta ): State also if X(t) is Wide Sense Stationary (WSS). plot 10 realisations of X(t) plotR(s-t,0)as a function of s-t "pramod kumar" <pramod.kilu@gmail.com> wrote in message <jpapso$44b$1@newscl01ah.mathworks.com>... > Let   U[0; 2theta] be a uniform random variable from the interval [0; 2theta] and let A  Exp(1) be exponentially distributed with mean 1. Assume  and A independent. Compute the mean mX(t) =E[X(t)] and autocorrelation RX(s; t) = E[X(s)X(t)] of the phase-shifted sinusoid.X(t) = A*  cos(t +theta ): > State also if X(t) is Wide Sense Stationary (WSS). > plot 10 realisations of X(t) > plotR(s-t,0)as a function of s-t So what have you tried? If you have not tried anything, this is a suggestion that you were not paying attention in class. Make an effort. John "pramod kumar" <pramod.kilu@gmail.com> wrote in message <jpapso$44b$1@newscl01ah.mathworks.com>... > Let   U[0; 2theta] be a uniform random variable from the interval [0; 2theta] and let A  Exp(1) be exponentially distributed with mean 1. Assume  and A independent. Compute the mean mX(t) =E[X(t)] and autocorrelation RX(s; t) = E[X(s)X(t)]...

Strange problem with secured database--Urgent HELP Needed
Hello ppl: I am facing a problem that I ahve never experienced before with the secured database. I created an MS Access 2000 application (.mdb) using MS Access 2002 and secured it using exactly the procedure described in the Access Security FAQ and as I have been doing since the time I have started using Access. So let the access application be xxx.mdb. After completing the whole development for xxx.mdb, i secured it using the procedure defined in the FAQ and created the Workgroup information file for it, say xxx_WIF.mdw. I tested it for my satisfaction and everything was working exactly the ...

need help urgent in stat problem
how to build the model and program it in sas : in each subject, 4 measures are done. - 1t at time 1 and 2nd at time 2 for factor 1; - 1t at time 1 and 2nd at time 2 for factor 2. there is dependance between time 2 and time 1 for each factor. there is dependance between factor 1 and factor 2 in each subject. dataset : case1 : subject factor time1 time2 1 factor1 12 50 1 factor2 10 20 2 factor1 12 15 2 factor2 16 70 3 factor1 9 90 3 factor2 1...

Urgent
Hi, I need help urgently......... My current os is WinXp Home (SP2). Everytime when during the windows start-up, it always appear the following message: Windows - No Disk X There is no disk in the drive. Please insert a disk into drive A: Cancel Try Again Continue Under the Taskbar, is shown my firewall "No firewall is turned on" After I click on the continue box, the error message disappeared and firewall auto ON back again. Pls kind enoguh to email me your reply to skyvansg@yahoo.com.sg greatly appreciated your kind assistance. ...

Problem in code...Need help urgent
Hello, I wrote the same program twice. following are the two codes. The upper one (slower) performs correctly, while the lower one(faster) doesn't produce the same result! Can anybody look into the program! I cant figure out what's the problem in the lower code? Thanks! Yi %%%psi : 400x2x3350 deltax=deltay=1 ph_Tx ,ph_Rx : 1x3350 zeta:2x3350 %%%%%code 1 for ii = 1 : 400 for ll = 1 : 3350 gamma(ii,1,ll) = sinc(zeta(1,ll)*deltax*cos(ph_Tx(ll))/pi)* sinc(zeta(1,ll)*deltay*sin(ph_Tx(ll))/pi)*psi(ii,1,ll); gamma(ii,2,ll) = sinc(zeta(2,ll)*deltax*cos(p...

Urgent
Hi, I need help urgently......... My current os is WinXp Home (SP2). Everytime when during the windows start-up, it always appear the following message: Windows - No Disk X - There is no disk in the drive. Please insert a disk into drive A: Cancel Try Again Continue Under the Taskbar, is shown my firewall "No firewall is turned on" After I click on the continue box, the error message disappeared and firewall auto ON back again. Pls kind enoguh to email me your reply to skyvansg@yahoo.com.sg greatly appreciated your kind assistance. ...

PThread Problem (Urgent Help Needed)
Hi, im trying to write a program that uses threads to search through an array of random numbers and then returns the total times that a specified target number occurs. The set up is that the user inputs the size of the array, the number of processors that they wish to simulate (number of threads created), and the target number that they want to search. The program then populates the array with random numbers, creates and runs the threads to search through array and increments the total each time that the target number is found. im having trouble writing the code to create the threads and run ...

Need Help Urgently with Strange Problem
I am using Ahead Nero on a Win 2000 computer with Access 2000. I have a database we printed reports from that is sorted in a particular way. When I look at the report on the screen prior to burning a CD with Nero, the onscreen data matches the printed copy. After I burn the CD, and without doing ANYTHING to the database but open it back up, the fields not included in Sorting and Grouping change their order. The onscreen reports (which the client wants to see along with the printed copies) do not match the printouts and I have no idea how to bring them back, since the sort of those fields appears to be completely random. What's really bizarre is that the local copy is "messed up" the same way as the CD copy. Does anyone have any idea what's going on here? Has anyone else had this problem with Nero? Thanks in advance, Janet Aldrich Janet, I've not heard of this problem before, but you may want to 1) try out a different burning product; for instance, try Windows' integrated burning program; 2) make sure you have the latest version of Nero (www.ahead.de). If you are still getting the same problem when burning with a different burning utility, you'll at least know that it's got to do with either your burner or Windows itself. I can't claim to know much about Nero, but I do know that Access doesn't guarantee the sort order of unsorted fields. If there's a particular sort order you want to return, define it in your report,...

Help needed with databases + asp problem
Hi, I'm new to databases & asp and am using dreamweaver mx 2004 (trial) to go about making dynamic pages. I was wondering if anyone could help me with a problem that I'm having, I would think its pretty easy to solve... Basically what I want to do is to have webpage showing the top news stories of the day with a limit of 3 database (ie news) entries per page. Obviously the top stories will change day by day and I will be adding them to the database via an asp form. This part is no problem. Where my problem arises is that if I limit the repeat region asp command to 3 entries o...

Matlab Problem, Need Help Urgent
Consider the integral ∫0 e-x sin(2x) dx ∏/4 a) Use the trapezoidal rule, and Simpson’s rule to approximate the integral. b) Compute the exact error in each case of part (a), and compare the exact error to the error bound associated for each integration method used. Hint: Use function s=simprl(f,a,b,M) %Input - f is the integrand input as a string 'f' % - a and b are upper and lower limits of integration % - M is the number of subintervals %Output - s is the simpson rule sum h=(b-a)/(2*M); s1=0; s2=0; for k=1:M x=a+h*(2*k-1); s1=s1+feval(f,x); e...

need help on a Logical problem for my database
Hello, I'm creating a discography for one artist on a web page. I started to create to database, but i'm stuck. This is the logic so far: i have a table named "album" i have another table called "track" 1 album contains multiple track, and 1 track can be in more then one album. So I created the table: album_track So far so good. Here's were i'm stuck. How do i represent multiple disc in one album? should i create another table called "disc" or do i insert the disc number somewhere in the "album_track" table along the position of the t...

Help needed on this 857W config. Repost to be clearer what the problems are and the help needed
Hi, Please see below config for my 857W. The basic topology is that I have one cisco857W and various servers and internal wired and wireless clients on the 192.168.0.0 255.255.255.0 network. There are a number of services running on the local lan, DNS and DHCP is also provided by a local server on the same subnet as the router. The 857W router sits on address 192.168.0.254 and needs to act as the local gateway for both wired and wireless clients. With this config booted on the router, the wireless clients can connect and authenticate and get allocated the correct DHCP information and ...

Urgent Help Needed With Tomcat + classpath problem
i am trying to run a servlet associated with a package i created using eclipse 2.1.1........everything compiles fine but i get the following errors when i try running the servlet. 2003-11-23 11:38:05 ContextListener: contextInitialized() 2003-11-23 11:38:05 SessionListener: contextInitialized() 2003-11-23 11:38:05 ContextListener: contextInitialized() 2003-11-23 11:38:05 SessionListener: contextInitialized() 2003-11-23 11:38:15 ----------- Creating the document object model from the W2DBML file. 2003-11-23 11:38:15 StandardWrapper.Throwable java.lang.NoClassDefFoundError: org/jdom/JDOMException at com.treelogic_swe.frameworks.web2database.Web2Database.init(Web2Database.java:344) at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1044) at org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:712) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:186) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:563) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:245) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:199) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:563) at org.apache.catalina.core...

Very Urgent- Database Creation problem please help.
[oracle@pslid2 Disk1]$ sh runInstaller Starting Oracle Universal Installer... Checking installer requirements... Checking operating system version: must be redhat-2.1, redhat-3, SuSE-9, SuSE-8 or UnitedLinux-1.0 Passed All installer requirements met. Hi Everyone: I am facing from one problem and it needs to be taken care of immediately. I can't open the display. I had setup the display by command: DISPLAY=$HOSTNAME:0.0; export DISPLAY Preparing to launch Oracle Universal Installer from /tmp/OraInstall2005-07-12_12-52-59AM. Please wait ...[orac...

problem with Cisco 3660
Hi all i have cisco 3660 with one FE when iam booting iam getting this following error and the Power supply LED going green and orange Could some one tell me what exactly the problem System Bootstrap, Version 12.0(6r)T, RELEASE SOFTWARE (fc1) Copyright (c) 1999 by cisco Systems, Inc. C3660 processor with 65536 Kbytes of main memory Main memory is configured to 64 bit mode with parity disabled *** System Environmental Interrupt *** Board Temperature and Power Supplies are normal *** System Environmental Interrupt *** WARNING: Power Supply 1 DC output failure. Power supply 1 Status = 0xa8...

Constructor problem
Hi, I have some code from an example, that I want to retrofit into my project. The code from the example has the following line: SharedAppenderPtr myAppender( new RollingFileAppender("MyAppender")) I want to move this line of code to a constructor in a wrapper class, so that I can determine the appropriate Appender name during the object's construction. I have done the ff: declared a privariate variable in my wrapper class as ff: SharedAppenderPtr m_Appender ; In my (wrapper class) constructor, I have the following code: ..... m_Appender = new RollingFileAppender(log...

Re: need help urgent in stat problem
I believe a gave a response to a similar question for continuous data a few weeks ago you can find at: http://www.listserv.uga.edu/cgi-bin/wa?A2=ind0901c&L=sas-l&F=&S=&P=2156 Robin High UNMC sousimou <elidrissi.M@GMAIL.COM> Sent by: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> 02/12/2009 01:29 AM Please respond to sousimou <elidrissi.M@GMAIL.COM> To SAS-L@LISTSERV.UGA.EDU cc Subject need help urgent in stat problem how to build the model and program it in sas : in each subject, 4 measures are done. - 1t at time 1 and 2nd at time...

Database planning - Hierarchical problem
Hi, I'm actually on a problem i don't manage to resolve. I want to implement a thing like this in a table : Albert John / \ / / \ / Bert Chuck / | \ / | \ / | \ / | \ Donna Eddie Fred \ / \ / \ / Gilbert ...

An Urgent Help needed for a complex transpose problem (
I have a follwoing dataset (with variabiles: serial, CARDIOBS, cARDIOWS, CNSBS, CNSWS) serial CARDIOBS CARDIOWS CNSBS CNSWS ------------------------------------------------------------------------- 1001 book/fashion book/fashion gyne/picko gune/picko /house /car 1002 book fashion/house none picko/rule 1004 none house gyne/picko not done /car Need to transpose variables ( or uing SQL ) as below and three...

Need Help to solve Matlab problem Urgently
Dear All, Anyone here can enlighten me where did i go wrong and how to amend my mistake in the matlab scripts (main script & function file), in order to get the plot out. Currently, there is no plot because there is an warning stating as Warning: Divide by zero. (Type "warning off MATLAB:divideByZero" to suppress this warning.) > In C:\MATLAB6p5\work\Assignment_Qn1new.m at line 44 Previous value q0 q1 q2 s ans = NaN NaN NaN NaN Latest value q0 q1 q2 s ans = NaN NaN NaN NaN My Matlab Main script are as follows: clear pack clc format long e M = 1601; % Number of...

Instancing problem with user control
I have a form1 through which a form2 is opened which has a picture box in which a user control is loaded but the problem is if I opens the form1, calls form2 and then close form2 and do this for 25 times the following error occurs: Class : iPMFunc.CreateUserControl Message : CreateUserControl Failed Err.No : 743 Err.Description : Unable to create or activate a new instance of 'PartyPCControl.uctPartyPCControl'. I tried the possibility of removing the picture box and using the user control on the form. Even this time the process failed but the error this t...

Big problem
Hi everyone, I'm having some big JS problems - my function is making my html code vanish, and I need help! Here's the code, try it for yourself. You'll notice that when you click either links and then look at the source code, it's all gone, apart from what the function is writing. How can I make the code just append the result under the links? I cannot use <div> or <layer> tags (show/hide). Thoughts?? <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta h...

Need Urgent Help in case of postgres Database Crash.
Hi , I am setting up a postgres 7.3 database for a big client.I don't want to lose any data in case of database crash or hardware failure . I need help in 1. Steps needed to setup the postgres database , is it posssible for me to write data on to two different disks. if so how? 2. Steps needed to recover the data in case of database crash or hardware crash. I would appreciate if some could help me out on these issues. Thanks in advance Somasekhar Bangalore Principle Software Engineer ZenSutra Software Technologies Pvt. Ltd. Suite 601, HM Geneva House #14, Cunningham Road Bang...

I need some help on Firebired function (triggers problem) PLS!
Hi! I have a question! How can I cut the first 5 letters of a variabile in Firebird Triggers? I try with LEFT(VAR,0,5) - Error! I try SUBSTRING(VAR,0,5) - Error! If any one know PLEASE HELP ME! mail me at adresasp@yahoo.de Thanks! Cretu wrote: > > Hi! > I have a question! > > How can I cut the first 5 letters of a variabile in Firebird Triggers? > I try with LEFT(VAR,0,5) - Error! > I try SUBSTRING(VAR,0,5) - Error! > > If any one know PLEASE HELP ME! I don't know, but try 1 instead of 0 in SUBSTRING(). SQL is usually ...

Web resources about - Urgent: Trigger problem... need help - comp.databases.btrieve

Resources last updated: 3/4/2016 12:01:15 AM