Sorry but SQL INSERT always does position on the new record. This is documented even in the helpfile:
---------------------------------------------------------------------------- - If the table you specify is open, SQL INSERT appends the new record to the table. If the table is open in a work area other than the current work area, it is not selected after the record is appended; the current work area remains selected.
If the table you specify is not open, Visual FoxPro opens it in a new work area, and the new record is appended to the table. The new work area is not selected; the current work area remains selected.
While the SQL INSERT command is executing, the current work area becomes the area into which the new record is inserted. In other words, when the SQL INSERT command is executed, it is in the context of the table being inserted into regardless of the current work area before the command was issued.
After executing the INSERT command, Visual FoxPro positions the
record pointer on the new record. <<<<<
Visual FoxPro updates the _TALLY system variable with the number of rows inserted if you include a SQL SELECT statement. For more information, see _TALLY System Variable. ---------------------------------------------------------------------------- -
wOOdy
[excessive quoting removed by server]