Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View Parameter name
Message
From
11/10/1999 15:30:27
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00274858
Message ID:
00275112
Views:
24
Hi Pete!

Use the view and use cSQL=CURSORGETPROP("SQL","ViewName") to get the SQL code to the memvar cSQL, then use AT() to find the "?" and then another AT to find the first space after the "?". Then use SUBSTR to extract the parm.

Orrr.....Use the view and see what parameter you're being asked for...this is the cheezy way.

Orrr..USE the database DBC. Locate for objecttype="View" and objectname="ViewName". Do the same AT() search and SUBSTR extraction I mentioned before.

>Hello gang,
>anyone know a way of: retrieving the name of a parameter used in a local view?
>
>TIA
>
>Pete Kane
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform