Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP breaks ODBC specification, please confirm
Message
From
18/12/2005 02:23:49
 
 
To
14/12/2005 05:04:47
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01077772
Message ID:
01079001
Views:
19
Hello Andrus,

i could reproduce the error.

You can also fix it yourself until the next SP is released (which takes too long to wait for):
IF SQLEXEC(connection,'UPDATE that fails') == -1
  SQLFix(connection)
  ....
ENDIF

FUNCTION SQLFix(lnCon)
#DEFINE SQL_RESET_PARAMS 3
LOCAL lnHstmt
lnHstmt = SQLGETPROP(lnCon,"ODBChstmt")
DECLARE SHORT SQLFreeStmt IN odbc32.dll INTEGER, SHORT
SQLFreeStmt(lnHstmt,SQL_RESET_PARAMS)
ENDFUNC
Regards
Christian
Previous
Reply
Map
View

Click here to load this message in the networking platform