General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only