Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View can't find database
Message
 
To
31/10/2000 10:05:27
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00436288
Message ID:
00436407
Views:
25
>>I have a dbc with several tables and a view. The view uses a table from a different dbc. In the past I would just add the table from the other
>>dbc to the view and everything would work fine. For some reason now, and I don't know what I did, every time I go to edit the view the
>>system can't find the external table and I have to browse for it. Any ideas on what is going wrong?
>
>Open the table's DBC
>Open the view's DBC then modify the view.
>
>Make sure the view's definition includes the database! before the table name in the FROM clause.
>
>Note: If the table is in a different database that the table, then it doesn't matter where the table's DBC is, as long as it is open.

What do I have to do with my app though? Do I have to explicitly open the other database? Just adding the table to the DE doesn't
do it.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform