>>
>>I'm thinking: the code uses lots of insert, Seek, replace, but it also uses Select-SQL. May be I need to change SELECT-SQL to LOCATE? It will also help us to eliminate duplicates still in buffer...
>>
>>What do you think?
>
>We used xBase when working on buffered tables - I had hoped for a switch to SQL with buffering, put your expierences make me hesitate a bit <bg>.
>
>regards
>
>thomas

See this Re: Select WITH Buffering = .t. Thread #1136217 Message #1136588 for discussion.