>>>>hello everybody.
>>>>
>>>>ok, i got a problem here i can't figure out. i get an error on the index command "File must be opened exclusive".
>>>
>>>Maybe your select is 100% optimize just opening up the original table again. I would stop after the select and see what DBF() returns.
>>
>>
>>hello Chuck.
>>
>>thanks for your reply, please see my message i just posted.
>
>You can open up the cursor exclusive again with out a problem. I still think the select is 100% optimize and your cursor is your original table of "invloc" just opened up again and filtered down.
well, i don't know. here is what i just tried (to re-open the curer exclusivly) and it throughs an error (file c:\temp\17e665.tmp not found). so i am sure the querry result is a seperate table/file
USE DBF(m.cSourceCursor) ALIAS (m.cTargetCursor) AGAIN
USE IN (m.cSourceCursor)
IF TYPE("m.cUserType") = "C" .AND. UPPER(m.cUserType) = "EXCL"
USE DBF(m.cTargetCursor) ALIAS (m.cTargetCursor) EXCL
ENDIF