ODBC problem
Bernard Devlin
revolution at knowledgeworks.plus.com
Sat Oct 12 09:57:01 EDT 2002
I have a repeatable problem with ODBC on Windows 2000 (SP 2).
When I try to use Rev to access a Firebird database via ODBC, I get the
following fatal error:
"The instruction at 'Ox10002b40' referenced memory at '0x00000038'. The memory
could not be 'read' "
This happens after the connection to the database has been established using
the Database Manager, and when I try to run a simple select statement.
On restarting Rev and repeating these steps, the problematic locations
referenced are different.
This only happens when I use the Easysoft drivers. When I use an open
source driver from XTG, there is no error. (You might just say 'well, stick
with that' - but I would like to ensure that I can use Rev, Firebird and
Easysoft - since Easysoft is the more established driver).
I also get a different error using the open source IBPhoenix ODBC driver. With
their driver I get:
"Invalid parameter index 0".
Again, I am just running a simple select query from the connection window that
is produced by the Database Manager.
I have tried run SQL queries against all three of these drivers with other
software, and there were no problems. (Please let me know if you think this is
a driver problem, and I will take this up with their respective developers.)
If you wish to reproduce the problem here are the locations for the pieces of
software I am referring to:
Firebird
http://prdownloads.sourceforge.net/firebird/Firebird-1.0.0.796-Win32.exe
Easysoft http://www.easysoft.com/support/trials.phtml?product=2201
IBPhoenix driver http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_60_odbc
------------------------
XTG drivers http://www.xtgsystems.com/linux/ofbodbc/download.php
The XTG open source driver works, so I hope that the availability of the source
code for both that driver and the IBPhoenix driver would enable you to find out
the problem Revolution has with the latter.
I have attaced the ODBCtrace file which has the operations in the following
order:
1) successful select using XTG driver
2) failed select using IBPhoenix driver
3) terminal failed select using Easysoft driver
Incidentally, another small problem with the query window thrown up by the
Database Manager - it defaults to ending a SQL query with a ";" at the end. I
have found with every driver I have used that this ";" is extraneous. It would
be better to omit it, as it will be misleading for people as the error that
ensues is unlikely to identify this as the problem.
I hope we can get this ODBC issue resolved.
I want to be able to use Firebird and Revolution for my business.
And I want to see Revolution become a major development platform. I am a
profession software developer with accreditions from Microsoft, Lotus and IBM,
currently working in a J2EE environment. But my aim is to build my business
using Revolution as one of my two principal development platforms. It is an
amazing product.
I am not making any more IT purchases until I can register my business in the
next week or two. Once I have done this I will be purchasing a license for Rev.
I can always use the XTG drivers, but would prefer to know that I can choose
between these different drivers if I find there are any other problems further
down the road.
Incidentally, I have already suggested that Runrev look at incorporating native
support (as with MySQL) for Firebird. There are many good reasons why you might
want to do this (I believe Geoff Canyon has been looking at this).
Regards,
Bernard Devlin
-------------- next part --------------
Revolution 3f0-448 ENTER SQLConnectW
HDBC 03411598
WCHAR * 0x03412730 [ -3] "fbXTGLocal\ 0"
SWORD -3
WCHAR * 0x1F7D8B70 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7D8B70 [ -3] "******\ 0"
SWORD -3
Revolution 3f0-448 EXIT SQLConnectW with return code 0 (SQL_SUCCESS)
HDBC 03411598
WCHAR * 0x03412730 [ -3] "fbXTGLocal\ 0"
SWORD -3
WCHAR * 0x1F7D8B70 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7D8B70 [ -3] "******\ 0"
SWORD -3
Revolution 3f0-448 ENTER SQLAllocStmt
HDBC 03411598
HSTMT * 0012F374
Revolution 3f0-448 EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS)
HDBC 03411598
HSTMT * 0x0012F374 ( 0x03411b30)
Revolution 3f0-448 ENTER SQLPrepare
HSTMT 03411B30
UCHAR * 0x00E10E70 [ 21] "select * from country"
SDWORD 21
Revolution 3f0-448 EXIT SQLPrepare with return code 0 (SQL_SUCCESS)
HSTMT 03411B30
UCHAR * 0x00E10E70 [ 21] "select * from country"
SDWORD 21
Revolution 3f0-448 ENTER SQLNumParams
HSTMT 03411B30
SWORD * 0x0012F354
Revolution 3f0-448 EXIT SQLNumParams with return code 0 (SQL_SUCCESS)
HSTMT 03411B30
SWORD * 0x0012F354 (0)
Revolution 3f0-448 ENTER SQLExecute
HSTMT 03411B30
Revolution 3f0-448 EXIT SQLExecute with return code 0 (SQL_SUCCESS)
HSTMT 03411B30
Revolution 3f0-448 ENTER SQLNumResultCols
HSTMT 03411B30
SWORD * 0x0012F384
Revolution 3f0-448 EXIT SQLNumResultCols with return code 0 (SQL_SUCCESS)
HSTMT 03411B30
SWORD * 0x0012F384 (2)
Revolution 3f0-448 ENTER SQLNumResultCols
HSTMT 03411B30
SWORD * 0x0012F34E
Revolution 3f0-448 EXIT SQLNumResultCols with return code 0 (SQL_SUCCESS)
HSTMT 03411B30
SWORD * 0x0012F34E (2)
Revolution 3f0-448 ENTER SQLRowCount
HSTMT 03411B30
SQLLEN * 0x0012F350
Revolution 3f0-448 EXIT SQLRowCount with return code 0 (SQL_SUCCESS)
HSTMT 03411B30
SQLLEN * 0x0012F350 (-1)
Revolution 3f0-448 ENTER SQLDescribeCol
HSTMT 03411B30
UWORD 1
UCHAR * 0x00E10CA4
SWORD 255
SWORD * 0x0012F32C
SWORD * 0x0012F32E
SQLLEN * 0x0012F340
SWORD * 0x0012F332
SWORD * 0x0012F330
Revolution 3f0-448 EXIT SQLDescribeCol with return code 0 (SQL_SUCCESS)
HSTMT 03411B30
UWORD 1
UCHAR * 0x00E10CA4 [ 7] "COUNTRY"
SWORD 255
SWORD * 0x0012F32C (7)
SWORD * 0x0012F32E (12)
SQLLEN * 0x0012F340 (15)
SWORD * 0x0012F332 (0)
SWORD * 0x0012F330 (0)
Revolution 3f0-448 ENTER SQLBindCol
HSTMT 03411B30
UWORD 1
SWORD 1 <SQL_C_CHAR>
PTR 0x00E10C80
SQLLEN 16
SQLLEN * 0x00E10DAC
Revolution 3f0-448 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 03411B30
UWORD 1
SWORD 1 <SQL_C_CHAR>
PTR 0x00E10C80
SQLLEN 16
SQLLEN * 0x00E10DAC (0)
Revolution 3f0-448 ENTER SQLDescribeCol
HSTMT 03411B30
UWORD 2
UCHAR * 0x00E10474
SWORD 255
SWORD * 0x0012F32C
SWORD * 0x0012F32E
SQLLEN * 0x0012F340
SWORD * 0x0012F332
SWORD * 0x0012F330
Revolution 3f0-448 EXIT SQLDescribeCol with return code 0 (SQL_SUCCESS)
HSTMT 03411B30
UWORD 2
UCHAR * 0x00E10474 [ 8] "CURRENCY"
SWORD 255
SWORD * 0x0012F32C (8)
SWORD * 0x0012F32E (12)
SQLLEN * 0x0012F340 (10)
SWORD * 0x0012F332 (0)
SWORD * 0x0012F330 (0)
Revolution 3f0-448 ENTER SQLBindCol
HSTMT 03411B30
UWORD 2
SWORD 1 <SQL_C_CHAR>
PTR 0x00E10C60
SQLLEN 11
SQLLEN * 0x00E1057C
Revolution 3f0-448 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 03411B30
UWORD 2
SWORD 1 <SQL_C_CHAR>
PTR 0x00E10C60
SQLLEN 11
SQLLEN * 0x00E1057C (0)
Revolution 3f0-448 ENTER SQLSetStmtOption
HSTMT 03411B30
UWORD 9 <SQL_ROWSET_SIZE>
SQLLEN 2427
Revolution 3f0-448 EXIT SQLSetStmtOption with return code 0 (SQL_SUCCESS)
HSTMT 03411B30
UWORD 9 <SQL_ROWSET_SIZE>
SQLLEN 2427
Revolution 3f0-448 ENTER SQLFetch
HSTMT 03411B30
Revolution 3f0-448 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 03411B30
Revolution 3f0-448 ENTER SQLFetch
HSTMT 03411B30
Revolution 3f0-448 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 03411B30
Revolution 3f0-448 ENTER SQLFetch
HSTMT 03411B30
Revolution 3f0-448 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 03411B30
Revolution 3f0-448 ENTER SQLFetch
HSTMT 03411B30
Revolution 3f0-448 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 03411B30
Revolution 3f0-448 ENTER SQLFetch
HSTMT 03411B30
Revolution 3f0-448 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 03411B30
Revolution 3f0-448 ENTER SQLFetch
HSTMT 03411B30
Revolution 3f0-448 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 03411B30
Revolution 3f0-448 ENTER SQLFetch
HSTMT 03411B30
Revolution 3f0-448 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 03411B30
Revolution 3f0-448 ENTER SQLFetch
HSTMT 03411B30
Revolution 3f0-448 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 03411B30
Revolution 3f0-448 ENTER SQLFetch
HSTMT 03411B30
Revolution 3f0-448 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 03411B30
Revolution 3f0-448 ENTER SQLFetch
HSTMT 03411B30
Revolution 3f0-448 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 03411B30
Revolution 3f0-448 ENTER SQLFetch
HSTMT 03411B30
Revolution 3f0-448 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 03411B30
Revolution 3f0-448 ENTER SQLFetch
HSTMT 03411B30
Revolution 3f0-448 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 03411B30
Revolution 3f0-448 ENTER SQLFetch
HSTMT 03411B30
Revolution 3f0-448 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 03411B30
Revolution 3f0-448 ENTER SQLFetch
HSTMT 03411B30
Revolution 3f0-448 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 03411B30
Revolution 3f0-448 ENTER SQLFetch
HSTMT 03411B30
Revolution 3f0-448 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 03411B30
Revolution 3f0-448 ENTER SQLFetch
HSTMT 03411B30
Revolution 3f0-448 EXIT SQLFetch with return code 100 (SQL_NO_DATA_FOUND)
HSTMT 03411B30
Revolution 3f0-448 ENTER SQLFreeStmt
HSTMT 03411B30
UWORD 1 <SQL_DROP>
Revolution 3f0-448 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 03411B30
UWORD 1 <SQL_DROP>
Revolution 3f0-448 ENTER SQLDisconnect
HDBC 03411598
Revolution 3f0-448 EXIT SQLDisconnect with return code 0 (SQL_SUCCESS)
HDBC 03411598
Revolution 3f0-448 ENTER SQLFreeConnect
HDBC 03411598
Revolution 3f0-448 EXIT SQLFreeConnect with return code 0 (SQL_SUCCESS)
HDBC 03411598
Revolution 3f0-448 ENTER SQLFreeEnv
HENV 034114F0
Revolution 3f0-448 EXIT SQLFreeEnv with return code 0 (SQL_SUCCESS)
HENV 034114F0
Revolution 3f0-448 ENTER SQLAllocEnv
HENV * 00E10EE0
Revolution 3f0-448 EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS)
HENV * 0x00E10EE0 ( 0x034114f0)
Revolution 3f0-448 ENTER SQLAllocConnect
HENV 034114F0
HDBC * 00E10EE4
Revolution 3f0-448 EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS)
HENV 034114F0
HDBC * 0x00E10EE4 ( 0x03411598)
Revolution 3f0-448 ENTER SQLDriverConnectW
HDBC 03411598
HWND 00000000
WCHAR * 0x1F7D8B70 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7D8B70
SWORD 8
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>
Revolution 3f0-448 EXIT SQLDriverConnectW with return code -1 (SQL_ERROR)
HDBC 03411598
HWND 00000000
WCHAR * 0x1F7D8B70 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7D8B70
SWORD 8
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>
DIAG [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0)
DIAG [01S00] [Microsoft][ODBC Driver Manager] Invalid connection string attribute (0)
Revolution 3f0-448 ENTER SQLConnectW
HDBC 03411598
WCHAR * 0x03411AA8 [ -3] "fbOpenLocal\ 0"
SWORD -3
WCHAR * 0x1F7D8B70 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7D8B70 [ -3] "******\ 0"
SWORD -3
Revolution 3f0-448 EXIT SQLConnectW with return code 0 (SQL_SUCCESS)
HDBC 03411598
WCHAR * 0x03411AA8 [ -3] "fbOpenLocal\ 0"
SWORD -3
WCHAR * 0x1F7D8B70 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7D8B70 [ -3] "******\ 0"
SWORD -3
Revolution 3f0-448 ENTER SQLAllocStmt
HDBC 03411598
HSTMT * 0012F374
Revolution 3f0-448 EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS)
HDBC 03411598
HSTMT * 0x0012F374 ( 0x03411b30)
Revolution 3f0-448 ENTER SQLPrepare
HSTMT 03411B30
UCHAR * 0x00E10E70 [ 21] "select * from country"
SDWORD 21
Revolution 3f0-448 EXIT SQLPrepare with return code 0 (SQL_SUCCESS)
HSTMT 03411B30
UCHAR * 0x00E10E70 [ 21] "select * from country"
SDWORD 21
Revolution 3f0-448 ENTER SQLNumParams
HSTMT 03411B30
SWORD * 0x0012F354
Revolution 3f0-448 EXIT SQLNumParams with return code 0 (SQL_SUCCESS)
HSTMT 03411B30
SWORD * 0x0012F354 (6960)
Revolution 3f0-448 ENTER SQLBindParameter
HSTMT 03411B30
UWORD 1
SWORD 1 <SQL_PARAM_INPUT>
SWORD 1 <SQL_C_CHAR>
SWORD 1 <SQL_CHAR>
SQLULEN 0
SWORD 0
PTR 0x005680AC
SQLLEN 0
SQLLEN * 0x00E10E60
Revolution 3f0-448 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 03411B30
UWORD 1
SWORD 1 <SQL_PARAM_INPUT>
SWORD 1 <SQL_C_CHAR>
SWORD 1 <SQL_CHAR>
SQLULEN 0
SWORD 0
PTR 0x005680AC
SQLLEN 0
SQLLEN * 0x00E10E60 (0)
Revolution 3f0-448 ENTER SQLExecute
HSTMT 03411B30
Revolution 3f0-448 EXIT SQLExecute with return code -1 (SQL_ERROR)
HSTMT 03411B30
DIAG [HY000] invalid parameter index 0 (-5)
Revolution 3f0-448 ENTER SQLErrorW
HENV 034114F0
HDBC 03411598
HSTMT 03411B30
WCHAR * 0x0012F330 (NYI)
SDWORD * 0x0012F364
WCHAR * 0x0012EF30
SWORD 511
SWORD * 0x0012F36C
Revolution 3f0-448 EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 034114F0
HDBC 03411598
HSTMT 03411B30
WCHAR * 0x0012F330 (NYI)
SDWORD * 0x0012F364 (-5)
WCHAR * 0x0012EF30 [ 25] "invalid para"
SWORD 511
SWORD * 0x0012F36C (25)
Revolution 3f0-448 ENTER SQLFreeStmt
HSTMT 03411B30
UWORD 1 <SQL_DROP>
Revolution 3f0-448 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 03411B30
UWORD 1 <SQL_DROP>
Revolution 3f0-448 ENTER SQLDisconnect
HDBC 03411598
Revolution 3f0-448 EXIT SQLDisconnect with return code 0 (SQL_SUCCESS)
HDBC 03411598
Revolution 3f0-448 ENTER SQLFreeConnect
HDBC 03411598
Revolution 3f0-448 EXIT SQLFreeConnect with return code 0 (SQL_SUCCESS)
HDBC 03411598
Revolution 3f0-448 ENTER SQLFreeEnv
HENV 034114F0
Revolution 3f0-448 EXIT SQLFreeEnv with return code 0 (SQL_SUCCESS)
HENV 034114F0
Revolution 3f0-448 ENTER SQLAllocEnv
HENV * 00E10EE0
Revolution 3f0-448 EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS)
HENV * 0x00E10EE0 ( 0x034114f0)
Revolution 3f0-448 ENTER SQLAllocConnect
HENV 034114F0
HDBC * 00E10EE4
Revolution 3f0-448 EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS)
HENV 034114F0
HDBC * 0x00E10EE4 ( 0x03411598)
Revolution 3f0-448 ENTER SQLDriverConnectW
HDBC 03411598
HWND 00000000
WCHAR * 0x1F7D8B70 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7D8B70
SWORD 8
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>
Revolution 3f0-448 EXIT SQLDriverConnectW with return code -1 (SQL_ERROR)
HDBC 03411598
HWND 00000000
WCHAR * 0x1F7D8B70 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7D8B70
SWORD 8
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>
DIAG [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0)
DIAG [01S00] [Microsoft][ODBC Driver Manager] Invalid connection string attribute (0)
Revolution 3f0-448 ENTER SQLConnectW
HDBC 03411598
WCHAR * 0x03411AA8 [ -3] "fbEasyLocal\ 0"
SWORD -3
WCHAR * 0x1F7D8B70 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7D8B70 [ -3] "******\ 0"
SWORD -3
Revolution 3f0-448 EXIT SQLConnectW with return code 0 (SQL_SUCCESS)
HDBC 03411598
WCHAR * 0x03411AA8 [ -3] "fbEasyLocal\ 0"
SWORD -3
WCHAR * 0x1F7D8B70 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7D8B70 [ -3] "******\ 0"
SWORD -3
Revolution 3f0-448 ENTER SQLAllocStmt
HDBC 03411598
HSTMT * 0012F374
Revolution 3f0-448 EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS)
HDBC 03411598
HSTMT * 0x0012F374 ( 0x03411b30)
Revolution 3f0-448 ENTER SQLPrepare
HSTMT 03411B30
UCHAR * 0x00E10E70 [ 21] "select * from country"
SDWORD 21
Revolution 3f0-448 EXIT SQLPrepare with return code 0 (SQL_SUCCESS)
HSTMT 03411B30
UCHAR * 0x00E10E70 [ 21] "select * from country"
SDWORD 21
Revolution 3f0-448 ENTER SQLNumParams
HSTMT 03411B30
SWORD * 0x0012F354
Revolution 3f0-448 EXIT SQLNumParams with return code 0 (SQL_SUCCESS)
HSTMT 03411B30
SWORD * 0x0012F354 (0)
Revolution 3f0-448 ENTER SQLExecute
HSTMT 03411B30
Revolution 3f0-448 EXIT SQLExecute with return code 0 (SQL_SUCCESS)
HSTMT 03411B30
Revolution 3f0-448 ENTER SQLNumResultCols
HSTMT 03411B30
SWORD * 0x0012F384
Revolution 3f0-448 EXIT SQLNumResultCols with return code 0 (SQL_SUCCESS)
HSTMT 03411B30
SWORD * 0x0012F384 (2)
Revolution 3f0-448 ENTER SQLNumResultCols
HSTMT 03411B30
SWORD * 0x0012F34E
Revolution 3f0-448 EXIT SQLNumResultCols with return code 0 (SQL_SUCCESS)
HSTMT 03411B30
SWORD * 0x0012F34E (2)
Revolution 3f0-448 ENTER SQLRowCount
HSTMT 03411B30
SQLLEN * 0x0012F350
Revolution 3f0-448 EXIT SQLRowCount with return code 0 (SQL_SUCCESS)
HSTMT 03411B30
SQLLEN * 0x0012F350 (-1)
Revolution 3f0-448 ENTER SQLDescribeCol
HSTMT 03411B30
UWORD 1
UCHAR * 0x00E10CA4
SWORD 255
SWORD * 0x0012F32C
SWORD * 0x0012F32E
SQLLEN * 0x0012F340
SWORD * 0x0012F332
SWORD * 0x0012F330
Revolution 3f0-448 EXIT SQLDescribeCol with return code 0 (SQL_SUCCESS)
HSTMT 03411B30
UWORD 1
UCHAR * 0x00E10CA4 [ 7] "COUNTRY"
SWORD 255
SWORD * 0x0012F32C (7)
SWORD * 0x0012F32E (12)
SQLLEN * 0x0012F340 (15)
SWORD * 0x0012F332 (0)
SWORD * 0x0012F330 (0)
Revolution 3f0-448 ENTER SQLBindCol
HSTMT 03411B30
UWORD 1
SWORD 1 <SQL_C_CHAR>
PTR 0x00E10C80
SQLLEN 16
SQLLEN * 0x00E10DAC
Revolution 3f0-448 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 03411B30
UWORD 1
SWORD 1 <SQL_C_CHAR>
PTR 0x00E10C80
SQLLEN 16
SQLLEN * 0x00E10DAC (0)
Revolution 3f0-448 ENTER SQLDescribeCol
HSTMT 03411B30
UWORD 2
UCHAR * 0x00E10474
SWORD 255
SWORD * 0x0012F32C
SWORD * 0x0012F32E
SQLLEN * 0x0012F340
SWORD * 0x0012F332
SWORD * 0x0012F330
Revolution 3f0-448 EXIT SQLDescribeCol with return code 0 (SQL_SUCCESS)
HSTMT 03411B30
UWORD 2
UCHAR * 0x00E10474 [ 8] "CURRENCY"
SWORD 255
SWORD * 0x0012F32C (8)
SWORD * 0x0012F32E (12)
SQLLEN * 0x0012F340 (10)
SWORD * 0x0012F332 (0)
SWORD * 0x0012F330 (0)
Revolution 3f0-448 ENTER SQLBindCol
HSTMT 03411B30
UWORD 2
SWORD 1 <SQL_C_CHAR>
PTR 0x00E10C60
SQLLEN 11
SQLLEN * 0x00E1057C
Revolution 3f0-448 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 03411B30
UWORD 2
SWORD 1 <SQL_C_CHAR>
PTR 0x00E10C60
SQLLEN 11
SQLLEN * 0x00E1057C (0)
Revolution 3f0-448 ENTER SQLSetStmtOption
HSTMT 03411B30
UWORD 9 <SQL_ROWSET_SIZE>
SQLLEN 2427
Revolution 3f0-448 EXIT SQLSetStmtOption with return code 0 (SQL_SUCCESS)
HSTMT 03411B30
UWORD 9 <SQL_ROWSET_SIZE>
SQLLEN 2427
Revolution 3f0-448 ENTER SQLFetch
HSTMT 03411B30
Revolution 3f0-448 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 03411B30
Revolution 3f0-448 ENTER SQLDisconnect
HDBC 03411598
More information about the use-livecode
mailing list