>> May it be because finalizing COMMIT (because dso_autocommit set) ? > > Probably. Please try dso_autocommitret. >
It works but is wrong in this scenario since refreshes the data with the SQL+params which includes INSERT/UPDATE operations internally => we have a double data update. The below code can also be a solution : ================ varar:= sqlresult.asvarinatar; sqlresult.tranaction.commit; // means no dso_autocommit* if vartoint(varar[0]) = 1 hen begin [...] end; ================ but looks cumbersome ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ mseide-msegui-talk mailing list mseide-msegui-talk@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk