>>Hi all
>>I created a parameterized view with 4 parameters. If i USE the view, it will ask me for the values, then a browse works with no problem, but since i have to requery it in my form, i do the following:
>>USE MyView nodata
>>vparam1="some value"
>>... etc ...
>>requery('MyView')
>>
>>There, i always get error number 1494: View Definition has been changed.
>>I also tried to run this from the command window, and even entering the parameters by hand after i run the requery, but there's nothing to do.
>>Using it normally will work though, so i'm getting quite frustrated...
>
--- I've had this when part of my query returns a field that when empty is smaller than when it contains a value. Sometimes I have had to add ..
IIF(ISNULL(something),000000.00,something). I found that if I captured the query at the time of loading and dumped it into a cursor so I could see it's structure it was not what I expected...
Hope It Helps,
Sandi.