>>>Using INSERT-SQL to create new record, you shouldn't care much where is current record.
>>
>>I read that "insert" requires the table to be opened exclusively. Is "insert-SQL" a different command? Can it be done with the table not opened exclusively?
>>
>>Thanks,
>
>These are different commands. INSERT-SQL (Insert into ... Values(...)) doesn't require exclusive usage, and INSERT (rarely used old command) does.


That's cool. I'll have to read up on it if it's in the help. Is it better to use this than append? That's what I usually use.

Thanks,