On Thu, Oct 3, 2019 at 9:50 AM Peter Cushing pcushing@whisperingsmith.com wrote:
Just looked at the help file and it says "After executing the *INSERT* command, Visual FoxPro positions the record pointer on the new record."
I did say "I think" as my Fox days are pretty much behind me.
I'm sure I have some code that may rely on this somewhere. Just wondering why you say INSERT INTO "may not"?
Don't confuse the INSERT [BLANK] command ( https://www.tedroche.com/hackfox7/s4g058.html) with the INSERT - SQL command (https://www.tedroche.com/hackfox7/s4g080.html) which are two different things.
When you execute one of the SQL commands, you are telling Fox what you want it to do, but not how to do it. The SQL interpreter may open the target file(s) in new work areas, with temporary aliases and perform the INSERT-SQL, UPDATE-SQL or DELETE-SQL without affecting the current work area or record pointers.
See a bigger discussion in "SQL - The Original" at https://www.tedroche.com/hackfox7/s1c4.html or Tamar Granor's excellent book, Taming Visual FoxPro's SQL, http://hentzenwerke.com/catalog/tamingvfpsql.htm