General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Assuming the view definition (the SQL statement) is still valid after the structure change(s), the way I do it is to retrieve the query text for the view using DBGETPROP('nameofview','VIEW','SQL') and place it into a character variable. I then DELETE VIEW nameofview and replace it by issuing a CREATE SQL VIEW command using the retrieve view definition and macro expansion. If you don't want the obsolete view in the DBC just PACK DATABASE.
>How do you programmatically update a view after you modify a structure so you don't get "base fields have changed" message
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