>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.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)