Of course, in a multi-user in environment you may want to use row or table buffering, in which case the duplicate file ID question becomes a non-issue since nothing happens until you call TABLEUPDATE.
I generally use APPEND BLANK when creating a blank buffered record for user input, and INSERT for just about everything else. Also, no real advantage to INSERT in buffered mode if you are not going to be replacing any values.
Just an opinion...
>>>As a side note instead of append blank
>>>
>>>insert into (lcChild) (quote_no) values (quoteinf.quote_no)
>>
>>What advantages does this have?
>
>The biggest advantage is that you NEVER get a blank record in the table, even for a split second. When many people are adding records simultaneously (or nearly so) the short time between
>append blank
>repl IDField with cNewID
>
can allow several people to add records, giving the dreaded 'duplicate file ID' message.
>
>Barbara
Eric Shaneson
Cutting Edge Consulting