update records fail on headerless form
Hi Everyone,
We have designed a headerless form to update just one customize table, but somehow when the update we found the the update sql used a where course not retrieved for a field's values on the row intend to be updated. The MCU should be 3516204.
Please see the following statement, I captured by fat client debug log.
UPDATE CONVDTA.F580902 SET GBICU=0.000000,GBCO='35161',GBLT='LT',GBACC='20201002',GBOBJ=' ',GBSUB=' ',GBDGL=0,GBC75TRTY=' ',GBBTNTEXT='Amt Due to Interco/Related (In',GBBTNVALUE=' ',GBPNID='22222',GBMCU=' 3516204',GBATEXT=' ',GBCRCD=' ',GBAN01=0.000000,GBAN02=0.000000,GBAN03=0.000000,GBAN04=0.000000,GBAN05=0.000000,GBAN06=0.000000,GBAN07=0.000000,GBAN08=0.000000,GBAN09=0.000000,GBAN10=0.000000,GBAN11=0.000000,GBAN12=0.000000,GBAN13=0.000000,GBAN14=0.000000,GBURCD=' ',GBURAB=0.000000,GBURAT=0.000000,GBUSER='LAMTY',GBPID='P580902',GBJOBN='WKS3987HK',GBUPMJ=114272,GBUPMT=122742.000000 WHERE ( GBICU = 0.000000 AND GBCO = '35161' AND GBLT = 'LT' AND GBACC = '20201002' AND GBC75TRTY = ' ' AND GBPNID = ' ' AND GBMCU = ' ' )