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

We use a method similar to the one used in FAQ and then just issue tableupdate.