I wasn't aware that there were different insert commands, I've always used
INSERT INTO CALL_TABLE (fieldPK, fieldCALLNUM, fieldDATE, fieldTIME) ;
VALUES (my_new_pk, my_callnum, DATE(), TIME())
~M
>Don't use the VFP INSERT command. Use the SQL INSERT command.
>
>>I'm looking at changing all the scatters..., about 7 in total, to inserts. I know that the scatter, append does not lock the file unless you do your own locking. I'm just wondering if the insert automatically does locking, or is it necessary as the record is inserted as opposed to adding a blank record and then populating it.
>>
>>~M
Go raibh maith agat
~M