>>>>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.
Thanks.
Didn't realize I was only testing in on Non-Updatable views.
Bill Morris