>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