>> 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

Reply via email to