>>>I can't get DbGetProp(cName,'View','Tables') to work, it always returns just empty spaces. I thought it would give me a list of tables that were used to create the view. I notice that it's read/write so I =DbSetProp('vNames','View','Tables','Names') then =dbGetProp('vNames','View','Tables') and it returns "Names".
>>>Is that what it's for, so I can assign tables to a view? What good is that?
>>>
>>>How can I get a list of tables that were used to create a view?
>>>
>>>TIA
>>
>>lcSQL = alltrim(dbgetprop(lcViewname,"view","sql"))
>
>Thanks, that helps. Still wish the 'Tables' option worked though.
The tables prop is really an 'updatetables' property. It is meant to be a space delimited list of tables that have update fields specified. If your view is not updateable, this property will return nothing.
Erik Moore
Clientelligence