>i have just decided to use sqlserver as back of my app.
>i use the SPT .
>to make the code conversion easier, i have created two functions :
>myrequery() to replace all requery() in forms with the sqlexec command. it works well.
>but for the second function myupdate() that must replace the tableupdate function i have some problems:
>the fonction must face many situations :
>- insert data if new record
>-update data if editing record
>-delete if deleted() record
>
>and the other hand the function must know if all records or current record.
>
>i need some help to make a good tableupdate() function.

Check:
SQL Pass-Through cursor that sends updates - Download #22850
A Simple SQL Pass-thru class - Download #15131
How to make SQL Pass-Through cursor updatable - FAQ #8153