>>>Hi
>>>
>>>I have a view that I want to change programmatically and I want to do it once if possible.
>>>
>>>Thanks
>>
>>Title : cursorgetprop('Tables',cViewName)
>>
>>Couldn't understand message.
>>Cetin
>
>Hi Cetin
>
>(example)I have a view:
>create sql view myView as;
>select a.field1, a.field2, b.field3, c.field4;
>from table1 a, table2 b, table3 c;
>....
>
>I want to see if table2 is used in the view WITHOUT opening the view, so I can update the view if table2 does not exist.
>
>Now, if I have to open the view to find out what table are used by using cursorgetprop('Tables',cViewName) then I believe I am getting a bug where the only result I get from using CursorGetprop('Tables',cViewName) is the name of 1 table.
>From my above example I get "table1" only instead of table1 , table2 and table3.
>
>in brief, I have to update a view by adding a table to it and I want to do it only once by checking if this new table already exist.
>In theory cursorgetprop('Tables',cViewName) should solve the rpoblem.
>
>Thanks
>Mo
Then query from dbc :
?DBGETPROP(ViewName,"VIEW","SQL")
?DBGETPROP(ViewName,"VIEW","Tables")
Cetin