Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cannot requery view, urgent! error 1494
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00666719
Message ID:
00667971
Views:
21
Eric
As i stated in an answer to Agnes and Sergey, i found the problem. There was a memo field in my select ( i couldn't see it at first because i have more than 40 output fields ), so changing it to left(memofield,...) fixed it.

Thanks
Jaime

>
>I had this problem once,
>-If it's a view including field of an another view, make sure to load in the dataenvironment the other view before the actual view.
>-Make sure to not use "as select *" in the definition of your view, because when you add a field to a table, all the view related to this file will have to be regenerate.
>
>Hope it help,
>Eric.
>
>>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...
>>
>>TIA
>>Jaime
Why do programs stop working correctly as soon as you leave the Fox?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform