On Thu, Oct 3, 2019 at 9:50 AM Peter Cushing <[email protected]> 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 -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/cacw6n4sjfwzz002qza+5yhewprfxghe2dmdeqhe603utj2g...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
