ODBC problem

Bernard Devlin revolution at knowledgeworks.plus.com
Sat Oct 12 09:57:01 CDT 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