I guess it's just personal preference:) My preference goes with "insert into" (especially if non buffered has pros over append blank/replace).
Cetin
>I guess I don't understand why you WOULD NOT use this command, or why there is a concern.
>what am I missing?
>
>
>>>Please give me an answer, can I use INSERT INTO command in multiuser application.
>>>Please reply as soon.
>>>
>>>Thanks
>>>Jignesh
>>
>>Sometimes it is considered the recommended approach. It is supposed to be faster, since there is one single command.
>>
>>But personally, for batch processing I prefer an APPEND BLANK, followed by a REPLACE. If this is combined with buffering, and transactions, it seems to me that I have more control over all the details. Tell me if you are interested in sample code.