Hi Steve ---
Erik Moore posted a really good View Designer replacement file here that is a lot more flexible than the native one.
>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.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05