I wonder about the use of the sql insert and update commands.

? In a form with private data session and mytable set in the dataenvironment; if I use the insert or update on mytable, will it use the occurence in dataenvironment. Will it change something in the record locking (I am using optimistic record locking) ? DO I need to perform a tableupdate() or is it done by the insert or update?

? After an insert or update, am I always pointed on the record or do I have to perform a find?

? Is it better to use insert/update instead of append blank/replace? Is there a performance gain or loss?

Thanks
Eric