Re: Visual FoxPro 9 ODBC errors

Thisis fixed this in December 2005.
Recent development snapshot does not have this problem.

This problem occurs only when Postgres returns error and VFP application
executes next statement i.e. in rare cases.

Andrus.

>There is an ODBC problem with Visual Foxpro 9. According to a Visual
>FoxPro maillist:

>Since VFP caches a common statement handle that it reuses, it has to call
>SQLFreeStmt(SQL_UNBIND) and SQLFreeStmt(SQL_RESET_PARAMS) to make sure the
>cached statement handle is in a cleared state before reusing it. VFP indeed
>calls these functions when all goes well, but when an error occurs in
>SQLExecuteDirect it just calls SQLCancel and then returns from
>SQLEXEC...... At least for me this is a bug in VFP, which is caused by the
>fact that it caches a common statement handle but doesn't reset it
>correctly when an error occurs.

>A thread does exist for the problem on the pgsql-odbc list under
Subject: Re: [ODBC] Access violation C5 error on Visual FoxPro SQLEXEC()
call after error