Re: unable to update a table

Looks like you forgot to COMMIT your transaction!!!!!!! COMMIT USING <your_transaction_object_name>; In powerbuilder check for return value from the update() function. IF dw_1.update() = 1 THEN COMMIT USING SQLCA; END IF If u are using dynamic SQL then check for the SQLCA.SQLCODE IF SQLCA.SQLCODE = 0 THEN COMMIT USING SQLCA; ELSE ROLL BACK USING SQLCA; //message END IF On Wed, 12 Aug 1998, Syed wrote: > Dear friends, > > I am having problem with one of my tables, whever I update from > Application, the update is not really updated in the database, although > no any error messages produced, however when I use the sql sytax in the > sql editor the update works. I have set the database logging on. > > Your kind help highly appreciated. > > Syed. > -- > Syed Ibrahim > Sapura Advanced Systems Sdn. Bhd, 18th Floor, Menara Tun Razak, Jalan > Raja Laut, 50350 Kuala Lumpur, Malaysia > Tel: (03) 295-3472, (03) 294-3000 Fax: (03) 294-6587, (03) 293-3154 >