Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Base Table Name of View
Message
From
07/06/2001 14:45:59
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00516515
Message ID:
00516546
Views:
9
>use
>lcProp = .property
>lcProp = AllTrim(SubStr(lcProp, AT(' from ', Lower(lcProp)) +5))
>lcTable = Left(lcProp, AT(Space(1), lcProp))

Hey Doug,

Not sure if I'm following... What is ".property" and how does the "use" fit in? What I'm trying to do is send a function the name of the base table of whatever the active view is at the time I call the function within the app. If my DBC is called Database1 and the base table is called Employee and the subsequent view is called v_Employee, I would want to send the parameter of "Employee" knowing that "v_Employee" is the view name. How would I plug all that into your code above at that time to return the base table name? Thanks!

ps. I got your e-mail last week but lightening struck next to our house and we lost phones/adsl/e-mail since Friday... I'll get back to you as soon as everything is back up... J
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform