Tried that first, before the scan.

Takes forever and a day.


>Kevin,
>
>

>update resh ;
>   set ...
>   where id in ( select id from localtable )
>

>
>>I query a network table to a local table. The local table is
>>used to populate a list.
>>
>>For every record in the local table, I need to mark it's network
>>copy so that no other users can access it.
>>
>>I have:
>>

>>** Get the alias of the local table
>>cAlias = ALIAS()
>>			
>>** Set the index of the network table
>>SET ORDER TO Id IN Resh
>>			
>>** Loop once for each local record
>>SELECT (cAlias)
>>SCAN
>>
>> ** Locate the network record
>> SELECT Resh
>> =SEEK(&cAlias..Id)
>>				
>> ** Store the batch id and user name to the network record
>> REPLACE IN Resh BatchNo WITH .nBatchNo,;
>>                 Used_By WITH oApp.cUserId;
>>                 NEXT 1
>>
>>ENDSCAN
>>

>>
>>The problem is that this is really slow.
>>
>>Anyone know how to speed this up?