Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why one table disappear from View structure
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00844061
Message ID:
00845997
Views:
8
>Using vfp 7, we create a view that depends of 4 tables. We test the view and everything work fine, but when we close all or run the program surrenly one or the tables disappear from the view (we open view designer and it's no more).

Plinio,
Prior to VFP 8, there were many problems with the View Designer. Once you reached a certain level of complexity, the designer couldn't hande it. While I've never heard it to delete a table from the table list, I wouldn't be surprised.

Prior to opening the view in the View Designer, use the view nodata. Issue the following:
? CursorgetProp('SQL','MyViewName')
See if the table is still there. If it is, open the view in the designer and see if the table goes away. If so, then it's a problem with the designer and that view. You'll have to maintain that view in code.

HTH.
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Previous
Reply
Map
View

Click here to load this message in the networking platform