Grigore,
Could you go ahead and post the SELECT statement for the view?
It would help me get a better handle on what's going on.
Thanks.
Also, sorry - need to read better - View definition has changed, not Base tables have changed... < slaps forehead >

---

>Hello.
>
>It's me again :)
>
>The same type of view works perfect under MSDE. I wonder if this is an ODBC drivers problem....
>
>More than that, if I issue a command like USE IN my_nasty_view, then set the new parameters and requery(), it works!
>
>I've tried the same situation in the Command Window:
>
>USE view NODATA
>parameter1="Grigore" && Name
>parameter2=5512 && zipcode
>REQUERY("view") && works fine
>parameter1="Trey" && new Name
>parameter2=1234 && zipcode
>REQUERY("view") && works fine.
>
>Now, in the form:
>
>view in dataenvironment, NoDataOnLoad=.T.
>
>In the click method of an push button:
>
>parameter1="Grigore" && in fact, I use a variable here and below
>parameter2=5512
>REQUERY("view") && works
>
>then I change the parameters, and click again on the same buton
>
>parameter1="Trey"
>parameter2=1234
>REQUERY("view") && and it give me the error 1494.
>
>Blame me, maybe I'm stupid, maybe I can't see the truth staring at me, but I can't figure why this thing happens. And I can't fix what I don't understand.
>
>(It's driving me crazy)
>
>Thank you.