No, I think it is running smoothly, there's something in the VFP I don't know about...
>Do you have an ON ERROR in affect that is allowing the error on the USE statement line to be ignored?
>
>>No error message, it just simply "skip" that bloody line and table "helyseg" stays in the data session.
>>
>>>I cannot see why the USE would not work. Do you get an error message when the program hits the line with USE? Also I would change the code to run like this;
>>>
>>>
>>>SET PROCEDURE TO C:\myprog\program\nohabc.prg ADDITIVE
>>>
>>>use C:\myprog\data\helyseg.dbf exclusive
>>>
>>>IF TAGNO( "NEV" ) > 0
>>> ALTER TABLE helyseg drop foreign KEY TAG NEV
>>>ENDIF
>>>
>>>RELEASE PROCEDURE C:\myprog\program\nohabc.prg
>>>
>>>USE IN "helyseg"
>>>
>>>
>>>
>>>>
>>>>>>Hi all,
>>>>>>I have a .prg file that calls another small file to get rid of the UDF on an index expression. It works fine, but if I want to close the altered table within this small file, it looks as if the "USE" command is skipped and ignored and the table stays open.
>>>>>>If this small file is not called, run by itself, the command "USE" works.
>>>>>>Why?
>>>>>>
>>>>>>Thanks
>>>>>>
>>>>>>Tamas Szigeti
>>>>>
>>>>>Hi Tamas. Can you post the code of the small file for everyone to review?