>>I am presently working on an application that requires a 200,000 record " delimited file into VFP. I am using Append from to do this. But I have heard that Insert - SQL works better and faster. The only example I can find shows how to do it with a single record. Is there a way to do it with multiple records?
>>
>>Thanks,
>>
>>Bill Chadbourne
>>wchad@ime.net
>Bill,
>
>APPEND FROM is the best way for your needs. You might try deleting the CDX file on teh DBF with a DELETE TAG ALL before the append and then INDEX ON after it to recreated those index tags. This is sometimes faster with large appends than appending with the indexes.
Thanks Jim,
I was just hoping there was a faster way.
Bill Chadbourne
wchad@ime.nat
William Chadbourne
Senior Programmer/Analyst
State of Maine - DAFS App Team
Oracle - When you care enough to use the very best!!