>>Using the COPY FROM and the original table is 41,700kb. The copy statement takes several minutes. Is there anyway to speed it up?
>>

>SELECT - SQL will provide the fastest. If all the records you need are together [i.e., you have an index on CustNum for every table], you can --

>seek nCustNum
>copy to test_table1 while CustNum = nCustNum

the statement in my program reads:

select * from collat ;
where alltrim(obligor) = alltrim(thisform.obligor);
into table (rpath+'tcollat')

it takes several minutes on a 41mb file. there is a index on the customer number. would i be better to SEEK and COPY WHILE?

Also, the SELECT will not work if someone has one of the records locked. Since this is a production file, there is always someone working. But I feel pretty sure they will not be working on the customer number I want to copy. will the SEEK work better for me?

Brenda