>is there any command need to use in order to clear any buffer for the sql connection ?
>or acutally no need to do any only do it by the server and client ?
Usually you work in autocommit mode, when any sql command is fixed automatica;y
When you make loop in your cursor at client and send updates to server it may cause to it big job for all steps.
If you go on the way I have described, server will accumulate more big portions of the data and fix it more rare , it is faster and easy for server
MVP-2006-2011, PHD in Math and Physics ,
host of
www.foxclub.ru,
VFP lector at Interface and Microinform companies
Head science researcher of VNIIA Rosatom.