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.