Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Why view breaks whenever I change table structure?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00391898
Message ID:
00391905
Vues:
15
Hi Alex,

This is quick and dirty but:

use MyDBC
list off ObjectName for ObjectType = 'View' and 'myfield' $ lower(property)

<snip>
>Is there any way to bring up a list or something showing all the views that include a particular table? For example, right now it would be nice to be able to list all the views that have been affected by the addition of a new field in mytable.dbf rather than wait for one of my forms to fail in order to "aha!
kenweber
GCom2 Solutions
Microsoft Certified Professional

Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform