>>>>But if you get the file and just import it in some other table, you don't need WITH (BUFFERING=.t.), you didn't change the file before importing, right?
>>>>What happens if you FLOCK() table before you insert records?
>>>
>>>This program is not mine and very long and complex. We may try to use flock(), I'm still thinking, should I forget about with buffering and try a different approach?
>>
>>If you don't change table before import you don't need buffering=.t., even if you change table, but it is not in Buffering mode you don't need this clause.
>
>In our case we're adding records to tables in table buffered mode.
If the main (or any other joined) table is buffrered and changed you definately need WITH (BUFFERING=.t.) or first TABLEUPDATE() and then SELECT.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.