Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DbGetProp(cName,'View','Tables') doesn't work.
Message
From
15/07/1998 12:53:57
 
 
To
14/07/1998 23:33:09
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00117424
Message ID:
00117671
Views:
17
>>I can't get DbGetProp(cName,'View','Tables') to work, it always returns just empty spaces. I thought it would give me a list of tables that were used to create the view. I notice that it's read/write so I =DbSetProp('vNames','View','Tables','Names') then =dbGetProp('vNames','View','Tables') and it returns "Names".
>>Is that what it's for, so I can assign tables to a view? What good is that?
>>
>>How can I get a list of tables that were used to create a view?
>>
>>TIA
>
>lcSQL = alltrim(dbgetprop(lcViewname,"view","sql"))

Thanks, that helps. Still wish the 'Tables' option worked though.
Bill Morris
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform