Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Why one table disappear from View structure
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00844061
Message ID:
00845997
Vues:
9
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform