>>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