Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP & MySQL
Message
From
30/11/2000 15:56:16
 
 
To
30/11/2000 11:41:18
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Miscellaneous
Thread ID:
00447415
Message ID:
00447667
Views:
9
>Hello.
>
>I have one problem that's driving me crazy: the error mesage 1494 "View definition has been changed".
>
>All I want to do is to requery an parameterized view against an MySQL table, changing the parameters. I have _not_ changed the view. I am positive about this. By issuing requery(), VFP give me the error above.
>
>Being out of my control, I can't fix this problem. Please, can anyone enlighten me about what's happening?
>
>Thank you

This error is caused by the results of one REQUERY() containing different field widths as the results of a previous REQUERY(). This error is usually caused by a view based on a view, or a function in the view definition SQL that doesn't consistently return the same width for a field (ALLTRIM, etc).

In your case, I would guess that the ODBC driver for the backend database is being inconsistent with the SQL results format, and it's confusing VFP. Does it happen if you REQUERY twice with the same parameter?
Erik Moore
Clientelligence
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform