Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only