Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
List of Views Using Base Table Or In Database
Message
 
 
To
30/08/2001 14:42:27
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00551021
Message ID:
00551035
Views:
21
This message has been marked as a message which has helped to the initial question of the thread.
>I've exhausted my understanding of dbGetProp and CursorGetProp... How can I get the name of all views using a particular base table? Or, if that is very complicated, then at least all the views contained in a specific database. Thanks!
>
>Regards, Renoir
This will create array with all views in the current database and return list of tables for the first view in the array
ADBOBJECTS(laArrayName, "VIEW")
?DDBGETPROP(laArrayName[1], "VIEW", "TABLES")
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform