Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Creating Views
Message
De
30/08/2000 22:13:10
 
 
À
30/08/2000 19:31:00
Robert Dinsmore
Dinsmore & Associates, Inc.
Lexington, Kentucky, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00411038
Message ID:
00411146
Vues:
16
>That's right - I created a view in the project using Create SQL View. I then opened that view from the project manager and saw the SQL statement that I had coded was changed. In addition, two tables that I had referenced in the SQL command did not even appear in the SQL code of the view.
>
>Are you saying that if you create a view in this manner, you cannot view the SQL code without the assistance of a utility?
>

You can - DBGETPROP("myview", "View", "SQL") is one way - it's just easier to use a utility to extract it and get the field and view settings.

>Where do I find GENDBCX?

It may be in the Files here on the UT - there's a couple of utilities at this link.
http://www.levelextreme.com/wconnect/wc.dll?UniversalThread~?2,2,800

>
>Thanks
Insanity: Doing the same thing over and over and expecting different results.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform