>>Dear All,
>>
>>Testing for multiple backends;
>>
>>When I try to build remote view filtered on single primary key using something like '?myPk'
>>as filter (where) expression for RV, VFP9 crushes every time. I am simply not able to exceute it even once.
>>If myPK is not populated it normally prompt me fopr value but then immediately afterwards VFP9 crushes.
>>
>>I did exactly the same with Oracle view/DSN and it did happen few times at very beginning, but now it all works. Fox dbc via ODBC also works perfectly fine. MS Access as well;
>>
>>What could be the problem here with mySQL ?!?
>
>Update;
>
>Sad 'solution' :(
>Apparently Fox have some kind of problem with mySql odbc driver 5.1
>BTW it is not only VFP9, it will crush VFP6 as well.
>
>So now I switched it to driver version 3.5.1 and it works up to now.
>Anybody made it work with version 5.1 ??
Didn't even know they had a 5. Worked fine with 3.5.1 last time I tried... some time last year, I think.