Re: INSERT is changing column value
Posted by:
joe conery
Date: December 01, 2004 03:04PM
The problem is actually worse...The insert statement causes most of the previously existing rows to change to that value as well. Here is an insert statement string that actually triggered the problem:
insert into transhistorytable (thr_primebroker, thr_counterpart ,thr_sectype ,thr_transid ,thr_currencypair, thr_trademethod , thr_tradetype , thr_tradeowner , thr_levmult , thr_buysell , thr_baseamount , thr_dollarbaseamount , thr_countercurrency , thr_traderate , thr_tradedate , thr_valuedate , thr_entrydate, thr_pbfee, thr_sendersubid, thr_fixmessage) VALUES ("UBS","ABN","FOR","BASIS-EURUSD_FOR_ABN_1101911686.191771_516","EUR/USD","FX Stream","Spot","account1","10","BUY",375000.0,0.0,-499275.0,1.3314,'2004-12-01 00:00:00','2004-12-03 00:00:00','2004-12-01 09:34:47',0.0,"CMEBasis","8=FIX.4.4^A9=267^A35=D^A34=589^A49=TRADE_CLEARER^A50=CMEBasis^A52=20041201-20:32:38.033^A56=COUNTERPART_WIN^A115=4^A128=2^A1=FX314596^A11=BASIS-EURUSD_FOR_ABN_1101911686.191771_516^A38=375000^A40=1^A44=1.3314^A54=1^A55=EUR/USD^A60=20041201-14:34:47^A63=0^A64=20041203^A75=20041201^A167=FOR^A207=ABN^A854=0^A10=208^A")
the thr_baseamount and thr_countercurrency columns are having problems.