>Perhaps 5.1 driver is still 'young' ;
>They will fix that driver eventually, til then 3.5.1 will do the job :).
>
>I was actually afraid that it has something to do with VFP9, so I got kind of 'relieved' when it worked just fine with older driver.
>
>
>
>Thank you guys
>Sergio
>
This bug has already been reported in the MySql bug database, I have updated the bug entry with new information, maybe this will get fixed soon:
http://bugs.mysql.com/bug.php?id=35067Notice what happens to the Select statement logged by MySQL in myodbc.sql when you turn debug on, near the WHERE clause when you use a parametrized view in VFP:
WHERE Stock.idcaja = ( _latin1'02DG0PQ0LQ' )
The same remote view with a fixed value instead of a variable turns out as:
WHERE Stock.idcaja = ( '02DG0PQ0LQ' )
So I guess that _latin1 thing is the root of the problem.
By the way, "They will fix that driver eventually" but only if someone reports the bug and can provide information about it, otherwise, it will never get fixed, more so if we talk about Visual FoxPro, I guess they don´t even have a VFP programmer.
This bug
http://bugs.mysql.com/bug.php?id=31968 was reported in OCT 2007, it finally got fixed in APR 2008:
http://bugs.mysql.com/bug.php?id=35581 after I lobbyed for it.
The funny thing is that I just did what any politician does, talk about something that I really had no idea about, just used what Christian Ehlscheid had written, and convinced them to fix it.
Christian even jumped in and got flamed, and he was the guy who really knew about the subject... that is how politics work I guess
Carlos Alloatti
