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
>>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 ?!?
>
>Same thing here with 5.1 driver. 3.51 works ok. Thanks for making me aware of this, I just switched to 5.1 this week and had not noticed this problem, I have not deplyed in production yet, thank god.
>
>I made a trace with both drivers:
>
>
>
>3.51 after select with parameter:
>
>vfp9 f04-f88 ENTER SQLFreeStmt
> HSTMT 02AB2010
> UWORD 3
>
>vfp9 f04-f88 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
> HSTMT 02AB2010
> UWORD 3
>
>vfp9 f04-f88 ENTER SQLNumResultCols
> HSTMT 02AB2010
> SWORD * 0x0012D0F0
>
>vfp9 f04-f88 EXIT SQLNumResultCols with return code 0 (SQL_SUCCESS)
> HSTMT 02AB2010
> SWORD * 0x0012D0F0 (27)
>
>... etc etc the log goes on about 1 MB more.
>
>5.1 after select with parameter:
>
>vfp9 f04-f88 ENTER SQLFreeStmt
> HSTMT 02AD1FE0
> UWORD 3
>
>vfp9 f04-f88 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
> HSTMT 02AD1FE0
> UWORD 3
>
>vfp9 f04-f88 ENTER SQLNumResultCols
> HSTMT 02AD1FE0
> SWORD * 0x0012D0F0
>
>Nothing more, VFP crashed here.
>>
>So I guess 5.1 is returning something wrong about number of columns? The remote view has 27 columns (fields)
>
>I will try to do more debugging with the debug version of the driver, if I can.
>
>Carlos Alloatti
