Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Trouble opening table with alias
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00168112
Message ID:
00168221
Views:
22
>I have a table named zip that is stored on disk as \vfpapps\sc\data\sczip.dbf in a database named sc.
>
>I issue the command in one form use zip in 0 and it works fine but in another form it does not work. With the form that it does not work in I get the error message that \vfpapps\sc\zip.dbf is not found. I determined that the database is open by issuing dbused('sc') and it returns true.
>
>I cannot determine why I get different results from the exact same commands in 2 different forms.
>
>Thanks,
>
>Paul

It appears that you may have the table with one name in the database and another *physical* name. To use the database name, the database must be open. I know your message indicated that it was open but I would suggest you try explictly opening it right before you USE.

HTH
Paul G Brown, MCSD
Paul G Brown
paul@paulgbrown.com
Previous
Reply
Map
View

Click here to load this message in the networking platform