Remote view on Mysql server

[OldSmelly]

Hello,

I have a very strange problem, I have a view in foxpro 9 to a mysql databaseserver with myodbc 3.51.12. When I run this view in de manager all runs fine but when I run it in the exe file and I do a requer of the view it alywas says "view defintion has been changed" and the program stops running.

I have tried every trick I know, I have updated to the latest Mysql odbc driver all to no avail..

Anyone knows what the *&^*^&*^is going on here ?

 

[OldSmelly]

Thanks for the answer but I don't have any formulas in the view. it's very strait forward Ony a condition is in there to get the data for only the key I want. More strangely is it , that when I don't have a condition the same view works alright .

 

[OldSmelly]

it's remote view with a condition created trough the manager

This is the code the manager created automaticly


SELECT Sexecodes.code, Sexecodes.omschrijving;
FROM ;
klv.sexecodes Sexecodes;
WHERE Sexecodes.code = ( ?gncode )

DBSetProp(ThisView,"View","SendUpdates",.F.)
DBSetProp(ThisView,"View","BatchUpdateCount",1)
DBSetProp(ThisView,"View","CompareMemo",.T.)
DBSetProp(ThisView,"View","FetchAsNeeded",.F.)
DBSetProp(ThisView,"View","FetchMemo",.T.)
DBSetProp(ThisView,"View","FetchSize",-1)
DBSetProp(ThisView,"View","MaxRecords",-1)
DBSetProp(ThisView,"View","Prepared",.F.)
DBSetProp(ThisView,"View","ShareConnection",.F.)
DBSetProp(ThisView,"View","AllowSimultaneousFetch",.F.)
DBSetProp(ThisView,"View","UpdateType",1)
DBSetProp(ThisView,"View","UseMemoSize",255)
DBSetProp(ThisView,"View","Tables","klv.sexecodes")
DBSetProp(ThisView,"View","WhereType",3)

DBSetProp(ThisView+".code","Field","DataType","C(10)")
DBSetProp(ThisView+".code","Field","UpdateName","klv.sexecodes.code")
DBSetProp(ThisView+".code","Field","KeyField",.T.)
DBSetProp(ThisView+".code","Field","Updatable",.F.)

DBSetProp(ThisView+".omschrijving","Field","DataType","C(50)")
DBSetProp(ThisView+".omschrijving","Field","UpdateName","klv.sexecodes.omschrijving")
DBSetProp(ThisView+".omschrijving","Field","KeyField",.F.)
DBSetProp(ThisView+".omschrijving","Field","Updatable",.T.)

 

[OldSmelly]

Just to be clear when I say manager I mean the vieuw designer

 

[OldSmelly]

I am testing further and it get's stranger...

When I open the view in a programm with the nodata clause and then I do a requery() then the error occurs, when I open the view without the nodata clause and a prefilles parameter it works fine !!!!

 

[OldSmelly]

I have found it !!!!! jippie....

In the myodbc driver you can tag the "don't optimize column width" .....

Thanks for the help