Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Prg called by prg
Message
From
04/01/2005 11:10:13
 
 
To
04/01/2005 09:00:28
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00974037
Message ID:
00974098
Views:
28
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?
Greg Reichert
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform