General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Limitations in View Designer?
I am trying to work around limitations in the view designer. Current problem is I need a condition in the WHERE clause like (EMPTY(solddate) OR solddate>?vp_solddate). This condition is ANDed with other conditons. I was not able to make the designer add such a condition, so I used gendbcx to create almost the right thing. I modified the code to put in the proper condition. Problem now is that when I attempt to requery the view after changing the value of the view parameter, I get the message 'View definition has changed.' Is there a way to get the view designer to use such a construct or to eliminate the requery problem? Thanks.
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