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