Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Base Table Name of View
Message
 
To
07/06/2001 14:09:05
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Base Table Name of View
Miscellaneous
Thread ID:
00516515
Message ID:
00516522
Views:
13
Renoir,

Here's a kludge to accomplish the first item.

use
lcProp = .property
lcProp = AllTrim(SubStr(lcProp, AT(' from ', Lower(lcProp)) +5))
lcTable = Left(lcProp, AT(Space(1), lcProp))

It's clumsy, but it's something. ;)

>Is there a way to determine in code the name of the table a view is based on? ...and what if a view is based on a view which is based on a table? Can I still get the original base table name? Thanks!
>
>Regards, Renoir
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform