General information
Category:
Coding, syntax & commands
>>Is it possible to make view as follows:?
>>SELECT * FROM table1 ;
>>UNION ;
>>SELECT * FROM table2
>>
>>Where table1 and table2 has identical structure.
>>
>>Giedrius
>Hi Giedrius,
>Yes you could do it just by adding "create sql view myViewName as .." in front. In view designer no way to do it AFAIK. I'm not sure of this but IMHO that would be practically a nonUpdatable view and hence not much different from an editable cursor (except that you could set some properites directly in DBC where for an editable cursor you should redo it on the fly).
>Cetin
Well not really - the way the updateable views are implemented in VFP you can do even worse things like creating a view on one table and updating a completely different one
Arnon
Previous
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