>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
Eric,
Insert is similar to append. Update is similar to replace. Insert also behave as an "append blank"+"replace". Behaviours differ with their optional clauses.
They would use your table and do not touch buffering. You again perform a tableupdate(). Record pointer would move.
Mostly SQL insert, update is superior to append/replace in performance. There are cases you would pick up the other but rare.
In short, start using SQL versions.
You can also check AppInsert topic at
www.foxforum.com, wiki.
Cetin