[psqlodbc-Bugs][1000790] String data field with only 1 letter length - Mailing list pgsql-odbc

From
Subject [psqlodbc-Bugs][1000790] String data field with only 1 letter length
Date
Msg-id 20150122072316.295D1DBABB4@pgfoundry.org
Whole thread Raw
List pgsql-odbc
psqlodbc-Bugs item #1000790, was changed at 2015-01-22 09:23 by Heikki Linnakangas
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000790&group_id=1000125
Or by replying to this e-mail entering your response between the following markers:
#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+
(enter your response here, only in plain text format)
#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+

>Status: Closed
Priority: 3
Submitted By: Nobody (None)
Assigned to: Nobody (None)
Summary: String data field with only 1 letter length
Category: None
Group: None
>Resolution: Out of Date
Category: None
Group: None
>Resolution: None


Initial Comment:
PostgreSQL 8.1.3
psqlODBC 8.02.02.00 Unicode

I use MFC (suppose to be 8.0 on VisualStudio 2005) CDatabase and CRecordset to retrieve data from a postgre database.
When the ODBC driver retrieve the data field type text that contain only 1 letter, CDBException is raised with return
codeis 100 

If I make the data 2 characters or more then it's ok

Putting data into the table is also ok.

I check the database with postgre admin, and the database look fine as the way it suppose to be.

Below is the log from the TRACE tool of ODBC Data Source Administrator


RestMenu        b14-34c    ENTER SQLAllocEnv
        HENV *              0015F7DC

RestMenu        b14-34c    EXIT  SQLAllocEnv  with return code 0 (SQL_SUCCESS)
        HENV *              0x0015F7DC ( 0x00e11690)

RestMenu        b14-34c    ENTER SQLAllocConnect
        HENV                00E11690
        HDBC *              00448B94

RestMenu        b14-34c    EXIT  SQLAllocConnect  with return code 0 (SQL_SUCCESS)
        HENV                00E11690
        HDBC *              0x00448B94 ( 0x00e11758)

RestMenu        b14-34c    ENTER SQLSetConnectOptionW
        HDBC                00E11758
        SQLINTEGER                 103 <SQL_LOGIN_TIMEOUT>
        SQLPOINTER          0x0000000F

RestMenu        b14-34c    EXIT  SQLSetConnectOptionW  with return code 0 (SQL_SUCCESS)
        HDBC                00E11758
        SQLINTEGER                 103 <SQL_LOGIN_TIMEOUT>
        SQLPOINTER          0x0000000F (BADMEM)

RestMenu        b14-34c    ENTER SQLDriverConnectW
        HDBC                00E11758
        HWND                00010014
        WCHAR *             0x74329A38 [      -3] "******\ 0"
        SWORD                       -3
        WCHAR *             0x74329A38
        SWORD                        2
        SWORD *             0x00000000
        UWORD                        1 <SQL_DRIVER_COMPLETE>

RestMenu        b14-34c    EXIT  SQLDriverConnectW  with return code 0 (SQL_SUCCESS)
        HDBC                00E11758
        HWND                00010014
        WCHAR *             0x74329A38 [      -3] "******\ 0"
        SWORD                       -3
        WCHAR *             0x74329A38
        SWORD                        2
        SWORD *             0x00000000
        UWORD                        1 <SQL_DRIVER_COMPLETE>

RestMenu        b14-34c    ENTER SQLGetInfoW
        HDBC                00E11758
        UWORD                        9 <SQL_ODBC_API_CONFORMANCE>
        PTR                 0x0012FB78
        SWORD                        2
        SWORD *             0x0012FB70

RestMenu        b14-34c    EXIT  SQLGetInfoW  with return code 0 (SQL_SUCCESS)
        HDBC                00E11758
        UWORD                        9 <SQL_ODBC_API_CONFORMANCE>
        PTR                 0x0012FB78 (1)
        SWORD                        2
        SWORD *             0x0012FB70 (2)

RestMenu        b14-34c    ENTER SQLGetInfoW
        HDBC                00E11758
        UWORD                       15 <SQL_ODBC_SQL_CONFORMANCE>
        PTR                 0x0012FB74
        SWORD                        2
        SWORD *             0x0012FB70

RestMenu        b14-34c    EXIT  SQLGetInfoW  with return code 0 (SQL_SUCCESS)
        HDBC                00E11758
        UWORD                       15 <SQL_ODBC_SQL_CONFORMANCE>
        PTR                 0x0012FB74 (1)
        SWORD                        2
        SWORD *             0x0012FB70 (2)

RestMenu        b14-34c    ENTER SQLGetInfoW
        HDBC                00E11758
        UWORD                       79 <SQL_POS_OPERATIONS>
        PTR                 0012FAEC
        SWORD                        4
        SWORD *             0x0012FAE4

RestMenu        b14-34c    EXIT  SQLGetInfoW  with return code 0 (SQL_SUCCESS)
        HDBC                00E11758
        UWORD                       79 <SQL_POS_OPERATIONS>
        PTR                 0012FAEC
        SWORD                        4
        SWORD *             0x0012FAE4 (4)

RestMenu        b14-34c    ENTER SQLGetInfoW
        HDBC                00E11758
        UWORD                       80 <SQL_POSITIONED_STATEMENTS>
        PTR                 0012FAF0
        SWORD                        4
        SWORD *             0x0012FAE4

RestMenu        b14-34c    EXIT  SQLGetInfoW  with return code 0 (SQL_SUCCESS)
        HDBC                00E11758
        UWORD                       80 <SQL_POSITIONED_STATEMENTS>
        PTR                 0012FAF0
        SWORD                        4
        SWORD *             0x0012FAE4 (4)

RestMenu        b14-34c    ENTER SQLGetInfoW
        HDBC                00E11758
        UWORD                       46 <SQL_TXN_CAPABLE>
        PTR                 0x0012FAD8
        SWORD                        2
        SWORD *             0x0012FAE4

RestMenu        b14-34c    EXIT  SQLGetInfoW  with return code 0 (SQL_SUCCESS)
        HDBC                00E11758
        UWORD                       46 <SQL_TXN_CAPABLE>
        PTR                 0x0012FAD8 (2)
        SWORD                        2
        SWORD *             0x0012FAE4 (2)

RestMenu        b14-34c    ENTER SQLGetInfoW
        HDBC                00E11758
        UWORD                       23 <SQL_CURSOR_COMMIT_BEHAVIOR>
        PTR                 0x00448BDA
        SWORD                        2
        SWORD *             0x0012FAE4

RestMenu        b14-34c    EXIT  SQLGetInfoW  with return code 0 (SQL_SUCCESS)
        HDBC                00E11758
        UWORD                       23 <SQL_CURSOR_COMMIT_BEHAVIOR>
        PTR                 0x00448BDA (2)
        SWORD                        2
        SWORD *             0x0012FAE4 (2)

RestMenu        b14-34c    ENTER SQLGetInfoW
        HDBC                00E11758
        UWORD                       24 <SQL_CURSOR_ROLLBACK_BEHAVIOR>
        PTR                 0x00448BDC
        SWORD                        2
        SWORD *             0x0012FAE4

RestMenu        b14-34c    EXIT  SQLGetInfoW  with return code 0 (SQL_SUCCESS)
        HDBC                00E11758
        UWORD                       24 <SQL_CURSOR_ROLLBACK_BEHAVIOR>
        PTR                 0x00448BDC (2)
        SWORD                        2
        SWORD *             0x0012FAE4 (2)

RestMenu        b14-34c    ENTER SQLGetInfoW
        HDBC                00E11758
        UWORD                       82 <SQL_BOOKMARK_PERSISTENCE>
        PTR                 00448BE4
        SWORD                        4
        SWORD *             0x0012FAE4

RestMenu        b14-34c    EXIT  SQLGetInfoW  with return code 0 (SQL_SUCCESS)
        HDBC                00E11758
        UWORD                       82 <SQL_BOOKMARK_PERSISTENCE>
        PTR                 00448BE4
        SWORD                        4
        SWORD *             0x0012FAE4 (4)

RestMenu        b14-34c    ENTER SQLGetInfoW
        HDBC                00E11758
        UWORD                       81 <SQL_GETDATA_EXTENSIONS>
        PTR                 0012FAE8
        SWORD                        4
        SWORD *             0x0012FAE4

RestMenu        b14-34c    EXIT  SQLGetInfoW  with return code 0 (SQL_SUCCESS)
        HDBC                00E11758
        UWORD                       81 <SQL_GETDATA_EXTENSIONS>
        PTR                 0012FAE8
        SWORD                        4
        SWORD *             0x0012FAE4 (4)

RestMenu        b14-34c    ENTER SQLGetInfoW
        HDBC                00E11758
        UWORD                       25 <SQL_DATA_SOURCE_READ_ONLY>
        PTR                 0x0012FAC4
        SWORD                       20
        SWORD *             0x0012FAE4

RestMenu        b14-34c    EXIT  SQLGetInfoW  with return code 0 (SQL_SUCCESS)
        HDBC                00E11758
        UWORD                       25 <SQL_DATA_SOURCE_READ_ONLY>
        PTR                 0x0012FAC4 [       2] "N"
        SWORD                       20
        SWORD *             0x0012FAE4 (2)

RestMenu        b14-34c    ENTER SQLGetInfoW
        HDBC                00E11758
        UWORD                       29 <SQL_IDENTIFIER_QUOTE_CHAR>
        PTR                 0x0012FAE0
        SWORD                        4
        SWORD *             0x0012FAE4

RestMenu        b14-34c    EXIT  SQLGetInfoW  with return code 0 (SQL_SUCCESS)
        HDBC                00E11758
        UWORD                       29 <SQL_IDENTIFIER_QUOTE_CHAR>
        PTR                 0x0012FAE0 [       2] """
        SWORD                        4
        SWORD *             0x0012FAE4 (2)

RestMenu        b14-34c    ENTER SQLGetInfoW
        HDBC                00E11758
        UWORD                       17 <SQL_DBMS_NAME>
        PTR                 0x0012FAF4
        SWORD                      128
        SWORD *             0x0012FAE4

RestMenu        b14-34c    EXIT  SQLGetInfoW  with return code 0 (SQL_SUCCESS)
        HDBC                00E11758
        UWORD                       17 <SQL_DBMS_NAME>
        PTR                 0x0012FAF4 [      20] "PostgreSQL"
        SWORD                      128
        SWORD *             0x0012FAE4 (20)

RestMenu        b14-34c    ENTER SQLGetInfoW
        HDBC                00E11758
        UWORD                       18 <SQL_DBMS_VER>
        PTR                 0x0012FAF4
        SWORD                      128
        SWORD *             0x0012FAE4

RestMenu        b14-34c    EXIT  SQLGetInfoW  with return code 1 (SQL_SUCCESS_WITH_INFO)
        HDBC                00E11758
        UWORD                       18 <SQL_DBMS_VER>
        PTR                 0x0012FAF4 [     128] "08.01.0200 PostgreSQL 8.1.3 on i686-pc-mingw32, compiled by GCC "
        SWORD                      128
        SWORD *             0x0012FAE4 (164)

        DIAG [01004] The buffer was too small for the InfoValue. (215)

RestMenu        b14-34c    ENTER SQLErrorW
        HENV                00E11690
        HDBC                00E11758
        HSTMT               00000000
        WCHAR *             0x0012F600 (NYI)
         SDWORD *            0x0012FA24
        WCHAR *             0x0012F620
        SWORD                      511
        SWORD *             0x0012F614

RestMenu        b14-34c    EXIT  SQLErrorW  with return code 100 (SQL_NO_DATA_FOUND)
        HENV                00E11690
        HDBC                00E11758
        HSTMT               00000000
        WCHAR *             0x0012F600 (NYI)
         SDWORD *            0x0012FA24
        WCHAR *             0x0012F620
        SWORD                      511
        SWORD *             0x0012F614

RestMenu        b14-34c    ENTER SQLGetInfoW
        HDBC                00E11758
        UWORD                       10 <SQL_ODBC_VER>
        PTR                 0x0012FAF4
        SWORD                      128
        SWORD *             0x0012FAE4

RestMenu        b14-34c    EXIT  SQLGetInfoW  with return code 0 (SQL_SUCCESS)
        HDBC                00E11758
        UWORD                       10 <SQL_ODBC_VER>
        PTR                 0x0012FAF4 [      20] "03.52.0000"
        SWORD                      128
        SWORD *             0x0012FAE4 (20)

RestMenu        b14-34c    ENTER SQLAllocStmt
        HDBC                00E11758
        HSTMT *             0012EDF8

RestMenu        b14-34c    EXIT  SQLAllocStmt  with return code 0 (SQL_SUCCESS)
        HDBC                00E11758
        HSTMT *             0x0012EDF8 ( 0x00e11cf8)

RestMenu        b14-34c    ENTER SQLNumResultCols
        HSTMT               00E11CF8
        SWORD *             0x0012EBF8

RestMenu        b14-34c    EXIT  SQLNumResultCols  with return code -1 (SQL_ERROR)
        HSTMT               00E11CF8
        SWORD *             0x0012EBF8

        DIAG [S1010] [Microsoft][ODBC Driver Manager] Function sequence error (0)

RestMenu        b14-34c    ENTER SQLErrorW
        HENV                00E11690
        HDBC                00E11758
        HSTMT               00E11CF8
        WCHAR *             0x0012E784 (NYI)
         SDWORD *            0x0012EBA8
        WCHAR *             0x0012E7A4
        SWORD                      511
        SWORD *             0x0012E798

RestMenu        b14-34c    EXIT  SQLErrorW  with return code 0 (SQL_SUCCESS)
        HENV                00E11690
        HDBC                00E11758
        HSTMT               00E11CF8
        WCHAR *             0x0012E784 (NYI)
         SDWORD *            0x0012EBA8 (0)
        WCHAR *             0x0012E7A4 [      56] "[Microsoft][ODBC Driver Manager] Function sequence error"
        SWORD                      511
        SWORD *             0x0012E798 (56)

RestMenu        b14-34c    ENTER SQLErrorW
        HENV                00E11690
        HDBC                00E11758
        HSTMT               00E11CF8
        WCHAR *             0x0012E784 (NYI)
         SDWORD *            0x0012EBA8
        WCHAR *             0x0012E7A4
        SWORD                      511
        SWORD *             0x0012E798

RestMenu        b14-34c    EXIT  SQLErrorW  with return code 100 (SQL_NO_DATA_FOUND)
        HENV                00E11690
        HDBC                00E11758
        HSTMT               00E11CF8
        WCHAR *             0x0012E784 (NYI)
         SDWORD *            0x0012EBA8
        WCHAR *             0x0012E7A4
        SWORD                      511
        SWORD *             0x0012E798

RestMenu        b14-34c    ENTER SQLSetStmtOption
        HSTMT               00E11CF8
        UWORD                        0 <SQL_QUERY_TIMEOUT>
        SQLPOINTER          0x0000000F

RestMenu        b14-34c    EXIT  SQLSetStmtOption  with return code 0 (SQL_SUCCESS)
        HSTMT               00E11CF8
        UWORD                        0 <SQL_QUERY_TIMEOUT>
        SQLPOINTER          0x0000000F (BADMEM)

RestMenu        b14-34c    ENTER SQLGetFunctions
        HDBC                00E11758
        UWORD                       59
        UWORD *             0x0012EBA8

RestMenu        b14-34c    EXIT  SQLGetFunctions  with return code 0 (SQL_SUCCESS)
        HDBC                00E11758
        UWORD                       59
        UWORD *             0x0012EBA8 (1)

RestMenu        b14-34c    ENTER SQLGetInfoW
        HDBC                00E11758
        UWORD                       10 <SQL_ODBC_VER>
        PTR                 0x0012EBB0
        SWORD                       60
        SWORD *             0x0012EBAC

RestMenu        b14-34c    EXIT  SQLGetInfoW  with return code 0 (SQL_SUCCESS)
        HDBC                00E11758
        UWORD                       10 <SQL_ODBC_VER>
        PTR                 0x0012EBB0 [      20] "03.52.0000"
        SWORD                       60
        SWORD *             0x0012EBAC (20)

RestMenu        b14-34c    ENTER SQLGetInfoW
        HDBC                00E11758
        UWORD                       44 <SQL_SCROLL_OPTIONS>
        PTR                 0012EBE8
        SWORD                        4
        SWORD *             0x0012EBE4

RestMenu        b14-34c    EXIT  SQLGetInfoW  with return code 0 (SQL_SUCCESS)
        HDBC                00E11758
        UWORD                       44 <SQL_SCROLL_OPTIONS>
        PTR                 0012EBE8
        SWORD                        4
        SWORD *             0x0012EBE4 (4)

RestMenu        b14-34c    ENTER SQLGetInfoW
        HDBC                00E11758
        UWORD                       43 <SQL_SCROLL_CONCURRENCY>
        PTR                 0012EEA0
        SWORD                        4
        SWORD *             0x0012EBE4

RestMenu        b14-34c    EXIT  SQLGetInfoW  with return code 0 (SQL_SUCCESS)
        HDBC                00E11758
        UWORD                       43 <SQL_SCROLL_CONCURRENCY>
        PTR                 0012EEA0
        SWORD                        4
        SWORD *             0x0012EBE4 (4)

RestMenu        b14-34c    ENTER SQLSetStmtOption
        HSTMT               00E11CF8
        UWORD                        6 <SQL_CURSOR_TYPE>
        SQLPOINTER          0x00000003

RestMenu        b14-34c    EXIT  SQLSetStmtOption  with return code 0 (SQL_SUCCESS)
        HSTMT               00E11CF8
        UWORD                        6 <SQL_CURSOR_TYPE>
        SQLPOINTER          0x00000003 (BADMEM)

RestMenu        b14-34c    ENTER SQLSetStmtOption
        HSTMT               00E11CF8
        UWORD                        7 <SQL_CONCURRENCY>
        SQLPOINTER          0x00000001

RestMenu        b14-34c    EXIT  SQLSetStmtOption  with return code 0 (SQL_SUCCESS)
        HSTMT               00E11CF8
        UWORD                        7 <SQL_CONCURRENCY>
        SQLPOINTER          0x00000001 (BADMEM)

RestMenu        b14-34c    ENTER SQLPrepareW
        HSTMT               00E11CF8
        WCHAR *             0x00359A68 [      -3] "SELECT * FROM "Menu"\ 0"
        SDWORD                    -3

RestMenu        b14-34c    EXIT  SQLPrepareW  with return code 0 (SQL_SUCCESS)
        HSTMT               00E11CF8
        WCHAR *             0x00359A68 [      -3] "SELECT * FROM "Menu"\ 0"
        SDWORD                    -3

RestMenu        b14-34c    ENTER SQLExecute
        HSTMT               00E11CF8

RestMenu        b14-34c    EXIT  SQLExecute  with return code 0 (SQL_SUCCESS)
        HSTMT               00E11CF8

RestMenu        b14-34c    ENTER SQLNumResultCols
        HSTMT               00E11CF8
        SWORD *             0x0012EE24

RestMenu        b14-34c    EXIT  SQLNumResultCols  with return code 0 (SQL_SUCCESS)
        HSTMT               00E11CF8
        SWORD *             0x0012EE24 (7)

RestMenu        b14-34c    ENTER SQLDescribeColW
        HSTMT               00E11CF8
        UWORD                        1
        WCHAR *             0x00359C68
        SWORD                      256
        SWORD *             0x0012EC04
        SWORD *             0x00359BB0
        SQLULEN *           0x00359BB4
        SWORD *             0x00359BB8
        SWORD *             0x00359BBA

RestMenu        b14-34c    EXIT  SQLDescribeColW  with return code 0 (SQL_SUCCESS)
        HSTMT               00E11CF8
        UWORD                        1
        WCHAR *             0x00359C68 [       6] "ItemID"
        SWORD                      256
        SWORD *             0x0012EC04 (6)
        SWORD *             0x00359BB0 (4)
        SQLULEN *           0x00359BB4 (10)
        SWORD *             0x00359BB8 (0)
        SWORD *             0x00359BBA (1)

RestMenu        b14-34c    ENTER SQLDescribeColW
        HSTMT               00E11CF8
        UWORD                        2
        WCHAR *             0x00359EB8
        SWORD                      256
        SWORD *             0x0012EC04
        SWORD *             0x00359BC0
        SQLULEN *           0x00359BC4
        SWORD *             0x00359BC8
        SWORD *             0x00359BCA

RestMenu        b14-34c    EXIT  SQLDescribeColW  with return code 0 (SQL_SUCCESS)
        HSTMT               00E11CF8
        UWORD                        2
        WCHAR *             0x00359EB8 [       8] "Category"
        SWORD                      256
        SWORD *             0x0012EC04 (8)
        SWORD *             0x00359BC0 (-10)
        SQLULEN *           0x00359BC4 (8190)
        SWORD *             0x00359BC8 (0)
        SWORD *             0x00359BCA (1)

RestMenu        b14-34c    ENTER SQLDescribeColW
        HSTMT               00E11CF8
        UWORD                        3
        WCHAR *             0x0035A108
        SWORD                      256
        SWORD *             0x0012EC04
        SWORD *             0x00359BD0
        SQLULEN *           0x00359BD4
        SWORD *             0x00359BD8
        SWORD *             0x00359BDA

RestMenu        b14-34c    EXIT  SQLDescribeColW  with return code 0 (SQL_SUCCESS)
        HSTMT               00E11CF8
        UWORD                        3
        WCHAR *             0x0035A108 [       4] "Desc"
        SWORD                      256
        SWORD *             0x0012EC04 (4)
        SWORD *             0x00359BD0 (-10)
        SQLULEN *           0x00359BD4 (8190)
        SWORD *             0x00359BD8 (0)
        SWORD *             0x00359BDA (1)

RestMenu        b14-34c    ENTER SQLDescribeColW
        HSTMT               00E11CF8
        UWORD                        4
        WCHAR *             0x0035D018
        SWORD                      256
        SWORD *             0x0012EC04
        SWORD *             0x00359BE0
        SQLULEN *           0x00359BE4
        SWORD *             0x00359BE8
        SWORD *             0x00359BEA

RestMenu        b14-34c    EXIT  SQLDescribeColW  with return code 0 (SQL_SUCCESS)
        HSTMT               00E11CF8
        UWORD                        4
        WCHAR *             0x0035D018 [      13] "ImageLocation"
        SWORD                      256
        SWORD *             0x0012EC04 (13)
        SWORD *             0x00359BE0 (-10)
        SQLULEN *           0x00359BE4 (8190)
        SWORD *             0x00359BE8 (0)
        SWORD *             0x00359BEA (1)

RestMenu        b14-34c    ENTER SQLDescribeColW
        HSTMT               00E11CF8
        UWORD                        5
        WCHAR *             0x0035D268
        SWORD                      256
        SWORD *             0x0012EC04
        SWORD *             0x00359BF0
        SQLULEN *           0x00359BF4
        SWORD *             0x00359BF8
        SWORD *             0x00359BFA

RestMenu        b14-34c    EXIT  SQLDescribeColW  with return code 0 (SQL_SUCCESS)
        HSTMT               00E11CF8
        UWORD                        5
        WCHAR *             0x0035D268 [       5] "Price"
        SWORD                      256
        SWORD *             0x0012EC04 (5)
        SWORD *             0x00359BF0 (7)
        SQLULEN *           0x00359BF4 (7)
        SWORD *             0x00359BF8 (0)
        SWORD *             0x00359BFA (1)

RestMenu        b14-34c    ENTER SQLDescribeColW
        HSTMT               00E11CF8
        UWORD                        6
        WCHAR *             0x0035D4B8
        SWORD                      256
        SWORD *             0x0012EC04
        SWORD *             0x00359C00
        SQLULEN *           0x00359C04
        SWORD *             0x00359C08
        SWORD *             0x00359C0A

RestMenu        b14-34c    EXIT  SQLDescribeColW  with return code 0 (SQL_SUCCESS)
        HSTMT               00E11CF8
        UWORD                        6
        WCHAR *             0x0035D4B8 [      13] "IsKitchenItem"
        SWORD                      256
        SWORD *             0x0012EC04 (13)
        SWORD *             0x00359C00 (1)
        SQLULEN *           0x00359C04 (1)
        SWORD *             0x00359C08 (0)
        SWORD *             0x00359C0A (1)

RestMenu        b14-34c    ENTER SQLDescribeColW
        HSTMT               00E11CF8
        UWORD                        7
        WCHAR *             0x0035D708
        SWORD                      256
        SWORD *             0x0012EC04
        SWORD *             0x00359C10
        SQLULEN *           0x00359C14
        SWORD *             0x00359C18
        SWORD *             0x00359C1A

RestMenu        b14-34c    EXIT  SQLDescribeColW  with return code 0 (SQL_SUCCESS)
        HSTMT               00E11CF8
        UWORD                        7
        WCHAR *             0x0035D708 [      13] "IsQtyInWeight"
        SWORD                      256
        SWORD *             0x0012EC04 (13)
        SWORD *             0x00359C10 (1)
        SQLULEN *           0x00359C14 (1)
        SWORD *             0x00359C18 (0)
        SWORD *             0x00359C1A (1)

RestMenu        b14-34c    ENTER SQLExtendedFetch
        HSTMT               00E11CF8
        UWORD                        1 <SQL_FETCH_NEXT>
        SQLLEN                     1
        SQLULEN *           0x0012EEAC
        UWORD *             0x0035C980

RestMenu        b14-34c    EXIT  SQLExtendedFetch  with return code 0 (SQL_SUCCESS)
        HSTMT               00E11CF8
        UWORD                        1 <SQL_FETCH_NEXT>
        SQLLEN                     1
        SQLULEN *           0x0012EEAC (1)
        UWORD *             0x0035C980 (0)

RestMenu        b14-34c    ENTER SQLGetData
        HSTMT               00E11CF8
        UWORD                        1
        SWORD                      -16 <SQL_C_SLONG>
        PTR                  1240148
        SQLLEN                     4
        SQLLEN *            0x0012EAF8

RestMenu        b14-34c    EXIT  SQLGetData  with return code 0 (SQL_SUCCESS)
        HSTMT               00E11CF8
        UWORD                        1
        SWORD                      -16 <SQL_C_SLONG>
        PTR                  1240148
        SQLLEN                     4
        SQLLEN *            0x0012EAF8 (4)

RestMenu        b14-34c    ENTER SQLGetData
        HSTMT               00E11CF8
        UWORD                        2
        SWORD                       -8 <SQL_C_WCHAR>
        PTR                 0x0035A398
        SQLLEN                     4
        SQLLEN *            0x0012EAF8

RestMenu        b14-34c    EXIT  SQLGetData  with return code 1 (SQL_SUCCESS_WITH_INFO)
        HSTMT               00E11CF8
        UWORD                        2
        SWORD                       -8 <SQL_C_WCHAR>
        PTR                 0x0035A398 [       4] "P\ 0"
        SQLLEN                     4
        SQLLEN *            0x0012EAF8 (6)

        DIAG [01004] The buffer was too small for the GetData. (-2)

RestMenu        b14-34c    ENTER SQLErrorW
        HENV                00E11690
        HDBC                00E11758
        HSTMT               00E11CF8
        WCHAR *             0x0012E670 (NYI)
         SDWORD *            0x0012EA94
        WCHAR *             0x0012E690
        SWORD                      511
        SWORD *             0x0012E684

RestMenu        b14-34c    EXIT  SQLErrorW  with return code 0 (SQL_SUCCESS)
        HENV                00E11690
        HDBC                00E11758
        HSTMT               00E11CF8
        WCHAR *             0x0012E670 (NYI)
         SDWORD *            0x0012EA94 (-2)
        WCHAR *             0x0012E690 [      41] "The buffer was too small for the GetData."
        SWORD                      511
        SWORD *             0x0012E684 (41)

RestMenu        b14-34c    ENTER SQLErrorW
        HENV                00E11690
        HDBC                00E11758
        HSTMT               00E11CF8
        WCHAR *             0x0012E670 (NYI)
         SDWORD *            0x0012EA94
        WCHAR *             0x0012E690
        SWORD                      511
        SWORD *             0x0012E684

RestMenu        b14-34c    EXIT  SQLErrorW  with return code 100 (SQL_NO_DATA_FOUND)
        HENV                00E11690
        HDBC                00E11758
        HSTMT               00E11CF8
        WCHAR *             0x0012E670 (NYI)
         SDWORD *            0x0012EA94
        WCHAR *             0x0012E690
        SWORD                      511
        SWORD *             0x0012E684

RestMenu        b14-34c    ENTER SQLGetData
        HSTMT               00E11CF8
        UWORD                        2
        SWORD                       -8 <SQL_C_WCHAR>
        PTR                 0x0035A39A
        SQLLEN                     6
        SQLLEN *            0x0012EAE8

RestMenu        b14-34c    EXIT  SQLGetData  with return code 0 (SQL_SUCCESS)
        HSTMT               00E11CF8
        UWORD                        2
        SWORD                       -8 <SQL_C_WCHAR>
        PTR                 0x0035A39A [       4] "h?"
        SQLLEN                     6
        SQLLEN *            0x0012EAE8 (4)

RestMenu        b14-34c    ENTER SQLGetData
        HSTMT               00E11CF8
        UWORD                        3
        SWORD                       -8 <SQL_C_WCHAR>
        PTR                 0x0035A398
        SQLLEN                     4
        SQLLEN *            0x0012EAF8

RestMenu        b14-34c    EXIT  SQLGetData  with return code 1 (SQL_SUCCESS_WITH_INFO)
        HSTMT               00E11CF8
        UWORD                        3
        SWORD                       -8 <SQL_C_WCHAR>
        PTR                 0x0035A398 [       4] "P\ 0"
        SQLLEN                     4
        SQLLEN *            0x0012EAF8 (24)

        DIAG [01004] The buffer was too small for the GetData. (-2)

RestMenu        b14-34c    ENTER SQLErrorW
        HENV                00E11690
        HDBC                00E11758
        HSTMT               00E11CF8
        WCHAR *             0x0012E670 (NYI)
         SDWORD *            0x0012EA94
        WCHAR *             0x0012E690
        SWORD                      511
        SWORD *             0x0012E684

RestMenu        b14-34c    EXIT  SQLErrorW  with return code 0 (SQL_SUCCESS)
        HENV                00E11690
        HDBC                00E11758
        HSTMT               00E11CF8
        WCHAR *             0x0012E670 (NYI)
         SDWORD *            0x0012EA94 (-2)
        WCHAR *             0x0012E690 [      41] "The buffer was too small for the GetData."
        SWORD                      511
        SWORD *             0x0012E684 (41)

RestMenu        b14-34c    ENTER SQLErrorW
        HENV                00E11690
        HDBC                00E11758
        HSTMT               00E11CF8
        WCHAR *             0x0012E670 (NYI)
         SDWORD *            0x0012EA94
        WCHAR *             0x0012E690
        SWORD                      511
        SWORD *             0x0012E684

RestMenu        b14-34c    EXIT  SQLErrorW  with return code 100 (SQL_NO_DATA_FOUND)
        HENV                00E11690
        HDBC                00E11758
        HSTMT               00E11CF8
        WCHAR *             0x0012E670 (NYI)
         SDWORD *            0x0012EA94
        WCHAR *             0x0012E690
        SWORD                      511
        SWORD *             0x0012E684

RestMenu        b14-34c    ENTER SQLGetData
        HSTMT               00E11CF8
        UWORD                        3
        SWORD                       -8 <SQL_C_WCHAR>
        PTR                 0x0035D95A
        SQLLEN                    24
        SQLLEN *            0x0012EAE8

RestMenu        b14-34c    EXIT  SQLGetData  with return code 0 (SQL_SUCCESS)
        HSTMT               00E11CF8
        UWORD                        3
        SWORD                       -8 <SQL_C_WCHAR>
        PTR                 0x0035D95A [      22] "h? \ff?t Bi?t"
        SQLLEN                    24
        SQLLEN *            0x0012EAE8 (22)

RestMenu        b14-34c    ENTER SQLGetData
        HSTMT               00E11CF8
        UWORD                        4
        SWORD                       -8 <SQL_C_WCHAR>
        PTR                 0x0035A358
        SQLLEN                     4
        SQLLEN *            0x0012EAF8

RestMenu        b14-34c    EXIT  SQLGetData  with return code 0 (SQL_SUCCESS)
        HSTMT               00E11CF8
        UWORD                        4
        SWORD                       -8 <SQL_C_WCHAR>
        PTR                 0x0035A358
        SQLLEN                     4
        SQLLEN *            0x0012EAF8 (0)

RestMenu        b14-34c    ENTER SQLGetData
        HSTMT               00E11CF8
        UWORD                        5
        SWORD                        7 <SQL_C_FLOAT>
        PTR                 <unknown type>
        SQLLEN                     4
        SQLLEN *            0x0012EAF8

RestMenu        b14-34c    EXIT  SQLGetData  with return code 0 (SQL_SUCCESS)
        HSTMT               00E11CF8
        UWORD                        5
        SWORD                        7 <SQL_C_FLOAT>
        PTR                 <unknown type>
        SQLLEN                     4
        SQLLEN *            0x0012EAF8 (4)

RestMenu        b14-34c    ENTER SQLGetData
        HSTMT               00E11CF8
        UWORD                        6
        SWORD                        1 <SQL_C_CHAR>
        PTR                 0x0035A398
        SQLLEN                     2
        SQLLEN *            0x0012EAF8

RestMenu        b14-34c    EXIT  SQLGetData  with return code 0 (SQL_SUCCESS)
        HSTMT               00E11CF8
        UWORD                        6
        SWORD                        1 <SQL_C_CHAR>
        PTR                 0x0035A398 [       1] "1"
        SQLLEN                     2
        SQLLEN *            0x0012EAF8 (1)

RestMenu        b14-34c    ENTER SQLGetData
        HSTMT               00E11CF8
        UWORD                        7
        SWORD                        1 <SQL_C_CHAR>
        PTR                 0x0035A398
        SQLLEN                     2
        SQLLEN *            0x0012EAF8

RestMenu        b14-34c    EXIT  SQLGetData  with return code 0 (SQL_SUCCESS)
        HSTMT               00E11CF8
        UWORD                        7
        SWORD                        1 <SQL_C_CHAR>
        PTR                 0x0035A398 [       1] "0"
        SQLLEN                     2
        SQLLEN *            0x0012EAF8 (1)

RestMenu        b14-34c    ENTER SQLExtendedFetch
        HSTMT               00E11CF8
        UWORD                        1 <SQL_FETCH_NEXT>
        SQLLEN                     1
        SQLULEN *           0x0012EEAC
        UWORD *             0x0035C980

RestMenu        b14-34c    EXIT  SQLExtendedFetch  with return code 0 (SQL_SUCCESS)
        HSTMT               00E11CF8
        UWORD                        1 <SQL_FETCH_NEXT>
        SQLLEN                     1
        SQLULEN *           0x0012EEAC (1)
        UWORD *             0x0035C980 (0)

RestMenu        b14-34c    ENTER SQLGetData
        HSTMT               00E11CF8
        UWORD                        1
        SWORD                      -16 <SQL_C_SLONG>
        PTR                  1240148
        SQLLEN                     4
        SQLLEN *            0x0012EAF8

RestMenu        b14-34c    EXIT  SQLGetData  with return code 0 (SQL_SUCCESS)
        HSTMT               00E11CF8
        UWORD                        1
        SWORD                      -16 <SQL_C_SLONG>
        PTR                  1240148
        SQLLEN                     4
        SQLLEN *            0x0012EAF8 (4)

RestMenu        b14-34c    ENTER SQLGetData
        HSTMT               00E11CF8
        UWORD                        2
        SWORD                       -8 <SQL_C_WCHAR>
        PTR                 0x0035DAD0
        SQLLEN                     4
        SQLLEN *            0x0012EAF8

RestMenu        b14-34c    EXIT  SQLGetData  with return code 1 (SQL_SUCCESS_WITH_INFO)
        HSTMT               00E11CF8
        UWORD                        2
        SWORD                       -8 <SQL_C_WCHAR>
        PTR                 0x0035DAD0 [       4] "P\ 0"
        SQLLEN                     4
        SQLLEN *            0x0012EAF8 (6)

        DIAG [01004] The buffer was too small for the GetData. (-2)

RestMenu        b14-34c    ENTER SQLErrorW
        HENV                00E11690
        HDBC                00E11758
        HSTMT               00E11CF8
        WCHAR *             0x0012E670 (NYI)
         SDWORD *            0x0012EA94
        WCHAR *             0x0012E690
        SWORD                      511
        SWORD *             0x0012E684

RestMenu        b14-34c    EXIT  SQLErrorW  with return code 0 (SQL_SUCCESS)
        HENV                00E11690
        HDBC                00E11758
        HSTMT               00E11CF8
        WCHAR *             0x0012E670 (NYI)
         SDWORD *            0x0012EA94 (-2)
        WCHAR *             0x0012E690 [      41] "The buffer was too small for the GetData."
        SWORD                      511
        SWORD *             0x0012E684 (41)

RestMenu        b14-34c    ENTER SQLErrorW
        HENV                00E11690
        HDBC                00E11758
        HSTMT               00E11CF8
        WCHAR *             0x0012E670 (NYI)
         SDWORD *            0x0012EA94
        WCHAR *             0x0012E690
        SWORD                      511
        SWORD *             0x0012E684

RestMenu        b14-34c    EXIT  SQLErrorW  with return code 100 (SQL_NO_DATA_FOUND)
        HENV                00E11690
        HDBC                00E11758
        HSTMT               00E11CF8
        WCHAR *             0x0012E670 (NYI)
         SDWORD *            0x0012EA94
        WCHAR *             0x0012E690
        SWORD                      511
        SWORD *             0x0012E684

RestMenu        b14-34c    ENTER SQLGetData
        HSTMT               00E11CF8
        UWORD                        2
        SWORD                       -8 <SQL_C_WCHAR>
        PTR                 0x0035DAD2
        SQLLEN                     6
        SQLLEN *            0x0012EAE8

RestMenu        b14-34c    EXIT  SQLGetData  with return code 0 (SQL_SUCCESS)
        HSTMT               00E11CF8
        UWORD                        2
        SWORD                       -8 <SQL_C_WCHAR>
        PTR                 0x0035DAD2 [       4] "h?"
        SQLLEN                     6
        SQLLEN *            0x0012EAE8 (4)

RestMenu        b14-34c    ENTER SQLGetData
        HSTMT               00E11CF8
        UWORD                        3
        SWORD                       -8 <SQL_C_WCHAR>
        PTR                 0x0035DAD0
        SQLLEN                     4
        SQLLEN *            0x0012EAF8

RestMenu        b14-34c    EXIT  SQLGetData  with return code 1 (SQL_SUCCESS_WITH_INFO)
        HSTMT               00E11CF8
        UWORD                        3
        SWORD                       -8 <SQL_C_WCHAR>
        PTR                 0x0035DAD0 [       4] "P\ 0"
        SQLLEN                     4
        SQLLEN *            0x0012EAF8 (14)

        DIAG [01004] The buffer was too small for the GetData. (-2)

RestMenu        b14-34c    ENTER SQLErrorW
        HENV                00E11690
        HDBC                00E11758
        HSTMT               00E11CF8
        WCHAR *             0x0012E670 (NYI)
         SDWORD *            0x0012EA94
        WCHAR *             0x0012E690
        SWORD                      511
        SWORD *             0x0012E684

RestMenu        b14-34c    EXIT  SQLErrorW  with return code 0 (SQL_SUCCESS)
        HENV                00E11690
        HDBC                00E11758
        HSTMT               00E11CF8
        WCHAR *             0x0012E670 (NYI)
         SDWORD *            0x0012EA94 (-2)
        WCHAR *             0x0012E690 [      41] "The buffer was too small for the GetData."
        SWORD                      511
        SWORD *             0x0012E684 (41)

RestMenu        b14-34c    ENTER SQLErrorW
        HENV                00E11690
        HDBC                00E11758
        HSTMT               00E11CF8
        WCHAR *             0x0012E670 (NYI)
         SDWORD *            0x0012EA94
        WCHAR *             0x0012E690
        SWORD                      511
        SWORD *             0x0012E684

RestMenu        b14-34c    EXIT  SQLErrorW  with return code 100 (SQL_NO_DATA_FOUND)
        HENV                00E11690
        HDBC                00E11758
        HSTMT               00E11CF8
        WCHAR *             0x0012E670 (NYI)
         SDWORD *            0x0012EA94
        WCHAR *             0x0012E690
        SWORD                      511
        SWORD *             0x0012E684

RestMenu        b14-34c    ENTER SQLGetData
        HSTMT               00E11CF8
        UWORD                        3
        SWORD                       -8 <SQL_C_WCHAR>
        PTR                 0x0035DB8A
        SQLLEN                    14
        SQLLEN *            0x0012EAE8

RestMenu        b14-34c    EXIT  SQLGetData  with return code 0 (SQL_SUCCESS)
        HSTMT               00E11CF8
        UWORD                        3
        SWORD                       -8 <SQL_C_WCHAR>
        PTR                 0x0035DB8A [      12] "h? T\ffm"
        SQLLEN                    14
        SQLLEN *            0x0012EAE8 (12)

RestMenu        b14-34c    ENTER SQLGetData
        HSTMT               00E11CF8
        UWORD                        4
        SWORD                       -8 <SQL_C_WCHAR>
        PTR                 0x0035DB88
        SQLLEN                     4
        SQLLEN *            0x0012EAF8

RestMenu        b14-34c    EXIT  SQLGetData  with return code 0 (SQL_SUCCESS)
        HSTMT               00E11CF8
        UWORD                        4
        SWORD                       -8 <SQL_C_WCHAR>
        PTR                 0x0035DB88
        SQLLEN                     4
        SQLLEN *            0x0012EAF8 (0)

RestMenu        b14-34c    ENTER SQLGetData
        HSTMT               00E11CF8
        UWORD                        5
        SWORD                        7 <SQL_C_FLOAT>
        PTR                 <unknown type>
        SQLLEN                     4
        SQLLEN *            0x0012EAF8

RestMenu        b14-34c    EXIT  SQLGetData  with return code 0 (SQL_SUCCESS)
        HSTMT               00E11CF8
        UWORD                        5
        SWORD                        7 <SQL_C_FLOAT>
        PTR                 <unknown type>
        SQLLEN                     4
        SQLLEN *            0x0012EAF8 (4)

RestMenu        b14-34c    ENTER SQLGetData
        HSTMT               00E11CF8
        UWORD                        6
        SWORD                        1 <SQL_C_CHAR>
        PTR                 0x0035DC30
        SQLLEN                     2
        SQLLEN *            0x0012EAF8

RestMenu        b14-34c    EXIT  SQLGetData  with return code 0 (SQL_SUCCESS)
        HSTMT               00E11CF8
        UWORD                        6
        SWORD                        1 <SQL_C_CHAR>
        PTR                 0x0035DC30 [       1] "1"
        SQLLEN                     2
        SQLLEN *            0x0012EAF8 (1)

RestMenu        b14-34c    ENTER SQLGetData
        HSTMT               00E11CF8
        UWORD                        7
        SWORD                        1 <SQL_C_CHAR>
        PTR                 0x0035DC30
        SQLLEN                     2
        SQLLEN *            0x0012EAF8

RestMenu        b14-34c    EXIT  SQLGetData  with return code 0 (SQL_SUCCESS)
        HSTMT               00E11CF8
        UWORD                        7
        SWORD                        1 <SQL_C_CHAR>
        PTR                 0x0035DC30 [       1] "0"
        SQLLEN                     2
        SQLLEN *            0x0012EAF8 (1)

RestMenu        b14-34c    ENTER SQLExtendedFetch
        HSTMT               00E11CF8
        UWORD                        1 <SQL_FETCH_NEXT>
        SQLLEN                     1
        SQLULEN *           0x0012EEAC
        UWORD *             0x0035C980

RestMenu        b14-34c    EXIT  SQLExtendedFetch  with return code 0 (SQL_SUCCESS)
        HSTMT               00E11CF8
        UWORD                        1 <SQL_FETCH_NEXT>
        SQLLEN                     1
        SQLULEN *           0x0012EEAC (1)
        UWORD *             0x0035C980 (0)

RestMenu        b14-34c    ENTER SQLGetData
        HSTMT               00E11CF8
        UWORD                        1
        SWORD                      -16 <SQL_C_SLONG>
        PTR                  1240148
        SQLLEN                     4
        SQLLEN *            0x0012EAF8

RestMenu        b14-34c    EXIT  SQLGetData  with return code 0 (SQL_SUCCESS)
        HSTMT               00E11CF8
        UWORD                        1
        SWORD                      -16 <SQL_C_SLONG>
        PTR                  1240148
        SQLLEN                     4
        SQLLEN *            0x0012EAF8 (4)

RestMenu        b14-34c    ENTER SQLGetData
        HSTMT               00E11CF8
        UWORD                        2
        SWORD                       -8 <SQL_C_WCHAR>
        PTR                 0x0035DC80
        SQLLEN                     4
        SQLLEN *            0x0012EAF8

RestMenu        b14-34c    EXIT  SQLGetData  with return code 1 (SQL_SUCCESS_WITH_INFO)
        HSTMT               00E11CF8
        UWORD                        2
        SWORD                       -8 <SQL_C_WCHAR>
        PTR                 0x0035DC80 [       4] "P\ 0"
        SQLLEN                     4
        SQLLEN *            0x0012EAF8 (6)

        DIAG [01004] The buffer was too small for the GetData. (-2)

RestMenu        b14-34c    ENTER SQLErrorW
        HENV                00E11690
        HDBC                00E11758
        HSTMT               00E11CF8
        WCHAR *             0x0012E670 (NYI)
         SDWORD *            0x0012EA94
        WCHAR *             0x0012E690
        SWORD                      511
        SWORD *             0x0012E684

RestMenu        b14-34c    EXIT  SQLErrorW  with return code 0 (SQL_SUCCESS)
        HENV                00E11690
        HDBC                00E11758
        HSTMT               00E11CF8
        WCHAR *             0x0012E670 (NYI)
         SDWORD *            0x0012EA94 (-2)
        WCHAR *             0x0012E690 [      41] "The buffer was too small for the GetData."
        SWORD                      511
        SWORD *             0x0012E684 (41)

RestMenu        b14-34c    ENTER SQLErrorW
        HENV                00E11690
        HDBC                00E11758
        HSTMT               00E11CF8
        WCHAR *             0x0012E670 (NYI)
         SDWORD *            0x0012EA94
        WCHAR *             0x0012E690
        SWORD                      511
        SWORD *             0x0012E684

RestMenu        b14-34c    EXIT  SQLErrorW  with return code 100 (SQL_NO_DATA_FOUND)
        HENV                00E11690
        HDBC                00E11758
        HSTMT               00E11CF8
        WCHAR *             0x0012E670 (NYI)
         SDWORD *            0x0012EA94
        WCHAR *             0x0012E690
        SWORD                      511
        SWORD *             0x0012E684

RestMenu        b14-34c    ENTER SQLGetData
        HSTMT               00E11CF8
        UWORD                        2
        SWORD                       -8 <SQL_C_WCHAR>
        PTR                 0x0035DC82
        SQLLEN                     6
        SQLLEN *            0x0012EAE8

RestMenu        b14-34c    EXIT  SQLGetData  with return code 0 (SQL_SUCCESS)
        HSTMT               00E11CF8
        UWORD                        2
        SWORD                       -8 <SQL_C_WCHAR>
        PTR                 0x0035DC82 [       4] "h?"
        SQLLEN                     6
        SQLLEN *            0x0012EAE8 (4)

RestMenu        b14-34c    ENTER SQLGetData
        HSTMT               00E11CF8
        UWORD                        3
        SWORD                       -8 <SQL_C_WCHAR>
        PTR                 0x0035DC80
        SQLLEN                     4
        SQLLEN *            0x0012EAF8

RestMenu        b14-34c    EXIT  SQLGetData  with return code 1 (SQL_SUCCESS_WITH_INFO)
        HSTMT               00E11CF8
        UWORD                        3
        SWORD                       -8 <SQL_C_WCHAR>
        PTR                 0x0035DC80 [       4] "P\ 0"
        SQLLEN                     4
        SQLLEN *            0x0012EAF8 (12)

        DIAG [01004] The buffer was too small for the GetData. (-2)

RestMenu        b14-34c    ENTER SQLErrorW
        HENV                00E11690
        HDBC                00E11758
        HSTMT               00E11CF8
        WCHAR *             0x0012E670 (NYI)
         SDWORD *            0x0012EA94
        WCHAR *             0x0012E690
        SWORD                      511
        SWORD *             0x0012E684

RestMenu        b14-34c    EXIT  SQLErrorW  with return code 0 (SQL_SUCCESS)
        HENV                00E11690
        HDBC                00E11758
        HSTMT               00E11CF8
        WCHAR *             0x0012E670 (NYI)
         SDWORD *            0x0012EA94 (-2)
        WCHAR *             0x0012E690 [      41] "The buffer was too small for the GetData."
        SWORD                      511
        SWORD *             0x0012E684 (41)

RestMenu        b14-34c    ENTER SQLErrorW
        HENV                00E11690
        HDBC                00E11758
        HSTMT               00E11CF8
        WCHAR *             0x0012E670 (NYI)
         SDWORD *            0x0012EA94
        WCHAR *             0x0012E690
        SWORD                      511
        SWORD *             0x0012E684

RestMenu        b14-34c    EXIT  SQLErrorW  with return code 100 (SQL_NO_DATA_FOUND)
        HENV                00E11690
        HDBC                00E11758
        HSTMT               00E11CF8
        WCHAR *             0x0012E670 (NYI)
         SDWORD *            0x0012EA94
        WCHAR *             0x0012E690
        SWORD                      511
        SWORD *             0x0012E684

RestMenu        b14-34c    ENTER SQLGetData
        HSTMT               00E11CF8
        UWORD                        3
        SWORD                       -8 <SQL_C_WCHAR>
        PTR                 0x0035DD3A
        SQLLEN                    12
        SQLLEN *            0x0012EAE8

RestMenu        b14-34c    EXIT  SQLGetData  with return code 0 (SQL_SUCCESS)
        HSTMT               00E11CF8
        UWORD                        3
        SWORD                       -8 <SQL_C_WCHAR>
        PTR                 0x0035DD3A [      10] "h? G\ff"
        SQLLEN                    12
        SQLLEN *            0x0012EAE8 (10)

RestMenu        b14-34c    ENTER SQLGetData
        HSTMT               00E11CF8
        UWORD                        4
        SWORD                       -8 <SQL_C_WCHAR>
        PTR                 0x0035DD38
        SQLLEN                     4
        SQLLEN *            0x0012EAF8

RestMenu        b14-34c    EXIT  SQLGetData  with return code 0 (SQL_SUCCESS)
        HSTMT               00E11CF8
        UWORD                        4
        SWORD                       -8 <SQL_C_WCHAR>
        PTR                 0x0035DD38
        SQLLEN                     4
        SQLLEN *            0x0012EAF8 (0)

RestMenu        b14-34c    ENTER SQLGetData
        HSTMT               00E11CF8
        UWORD                        5
        SWORD                        7 <SQL_C_FLOAT>
        PTR                 <unknown type>
        SQLLEN                     4
        SQLLEN *            0x0012EAF8

RestMenu        b14-34c    EXIT  SQLGetData  with return code 0 (SQL_SUCCESS)
        HSTMT               00E11CF8
        UWORD                        5
        SWORD                        7 <SQL_C_FLOAT>
        PTR                 <unknown type>
        SQLLEN                     4
        SQLLEN *            0x0012EAF8 (4)

RestMenu        b14-34c    ENTER SQLGetData
        HSTMT               00E11CF8
        UWORD                        6
        SWORD                        1 <SQL_C_CHAR>
        PTR                 0x0035DDE0
        SQLLEN                     2
        SQLLEN *            0x0012EAF8

RestMenu        b14-34c    EXIT  SQLGetData  with return code 0 (SQL_SUCCESS)
        HSTMT               00E11CF8
        UWORD                        6
        SWORD                        1 <SQL_C_CHAR>
        PTR                 0x0035DDE0 [       1] "1"
        SQLLEN                     2
        SQLLEN *            0x0012EAF8 (1)

RestMenu        b14-34c    ENTER SQLGetData
        HSTMT               00E11CF8
        UWORD                        7
        SWORD                        1 <SQL_C_CHAR>
        PTR                 0x0035DDE0
        SQLLEN                     2
        SQLLEN *            0x0012EAF8

RestMenu        b14-34c    EXIT  SQLGetData  with return code 0 (SQL_SUCCESS)
        HSTMT               00E11CF8
        UWORD                        7
        SWORD                        1 <SQL_C_CHAR>
        PTR                 0x0035DDE0 [       1] "0"
        SQLLEN                     2
        SQLLEN *            0x0012EAF8 (1)

RestMenu        b14-34c    ENTER SQLExtendedFetch
        HSTMT               00E11CF8
        UWORD                        1 <SQL_FETCH_NEXT>
        SQLLEN                     1
        SQLULEN *           0x0012EEAC
        UWORD *             0x0035C980

RestMenu        b14-34c    EXIT  SQLExtendedFetch  with return code 0 (SQL_SUCCESS)
        HSTMT               00E11CF8
        UWORD                        1 <SQL_FETCH_NEXT>
        SQLLEN                     1
        SQLULEN *           0x0012EEAC (1)
        UWORD *             0x0035C980 (0)

RestMenu        b14-34c    ENTER SQLGetData
        HSTMT               00E11CF8
        UWORD                        1
        SWORD                      -16 <SQL_C_SLONG>
        PTR                  1240148
        SQLLEN                     4
        SQLLEN *            0x0012EAF8

RestMenu        b14-34c    EXIT  SQLGetData  with return code 0 (SQL_SUCCESS)
        HSTMT               00E11CF8
        UWORD                        1
        SWORD                      -16 <SQL_C_SLONG>
        PTR                  1240148
        SQLLEN                     4
        SQLLEN *            0x0012EAF8 (4)

RestMenu        b14-34c    ENTER SQLGetData
        HSTMT               00E11CF8
        UWORD                        2
        SWORD                       -8 <SQL_C_WCHAR>
        PTR                 0x0035DDE0
        SQLLEN                     4
        SQLLEN *            0x0012EAF8

RestMenu        b14-34c    EXIT  SQLGetData  with return code 1 (SQL_SUCCESS_WITH_INFO)
        HSTMT               00E11CF8
        UWORD                        2
        SWORD                       -8 <SQL_C_WCHAR>
        PTR                 0x0035DDE0 [       4] "P\ 0"
        SQLLEN                     4
        SQLLEN *            0x0012EAF8 (6)

        DIAG [01004] The buffer was too small for the GetData. (-2)

RestMenu        b14-34c    ENTER SQLErrorW
        HENV                00E11690
        HDBC                00E11758
        HSTMT               00E11CF8
        WCHAR *             0x0012E670 (NYI)
         SDWORD *            0x0012EA94
        WCHAR *             0x0012E690
        SWORD                      511
        SWORD *             0x0012E684

RestMenu        b14-34c    EXIT  SQLErrorW  with return code 0 (SQL_SUCCESS)
        HENV                00E11690
        HDBC                00E11758
        HSTMT               00E11CF8
        WCHAR *             0x0012E670 (NYI)
         SDWORD *            0x0012EA94 (-2)
        WCHAR *             0x0012E690 [      41] "The buffer was too small for the GetData."
        SWORD                      511
        SWORD *             0x0012E684 (41)

RestMenu        b14-34c    ENTER SQLErrorW
        HENV                00E11690
        HDBC                00E11758
        HSTMT               00E11CF8
        WCHAR *             0x0012E670 (NYI)
         SDWORD *            0x0012EA94
        WCHAR *             0x0012E690
        SWORD                      511
        SWORD *             0x0012E684

RestMenu        b14-34c    EXIT  SQLErrorW  with return code 100 (SQL_NO_DATA_FOUND)
        HENV                00E11690
        HDBC                00E11758
        HSTMT               00E11CF8
        WCHAR *             0x0012E670 (NYI)
         SDWORD *            0x0012EA94
        WCHAR *             0x0012E690
        SWORD                      511
        SWORD *             0x0012E684

RestMenu        b14-34c    ENTER SQLGetData
        HSTMT               00E11CF8
        UWORD                        2
        SWORD                       -8 <SQL_C_WCHAR>
        PTR                 0x0035DDE2
        SQLLEN                     6
        SQLLEN *            0x0012EAE8

RestMenu        b14-34c    EXIT  SQLGetData  with return code 0 (SQL_SUCCESS)
        HSTMT               00E11CF8
        UWORD                        2
        SWORD                       -8 <SQL_C_WCHAR>
        PTR                 0x0035DDE2 [       4] "h?"
        SQLLEN                     6
        SQLLEN *            0x0012EAE8 (4)

RestMenu        b14-34c    ENTER SQLGetData
        HSTMT               00E11CF8
        UWORD                        3
        SWORD                       -8 <SQL_C_WCHAR>
        PTR                 0x0035DDE0
        SQLLEN                     4
        SQLLEN *            0x0012EAF8

RestMenu        b14-34c    EXIT  SQLGetData  with return code 0 (SQL_SUCCESS)
        HSTMT               00E11CF8
        UWORD                        3
        SWORD                       -8 <SQL_C_WCHAR>
        PTR                 0x0035DDE0 [       2] "p"
        SQLLEN                     4
        SQLLEN *            0x0012EAF8 (2)

RestMenu        b14-34c    ENTER SQLGetData
        HSTMT               00E11CF8
        UWORD                        3
        SWORD                       -8 <SQL_C_WCHAR>
        PTR                 0x0035DDE2
        SQLLEN                     2
        SQLLEN *            0x0012EAE8

RestMenu        b14-34c    EXIT  SQLGetData  with return code 100 (SQL_NO_DATA_FOUND)
        HSTMT               00E11CF8
        UWORD                        3
        SWORD                       -8 <SQL_C_WCHAR>
        PTR                 0x0035DDE2
        SQLLEN                     2
        SQLLEN *            0x0012EAE8

RestMenu        b14-34c    ENTER SQLFreeStmt
        HSTMT               00E11CF8
        UWORD                        1 <SQL_DROP>

RestMenu        b14-34c    EXIT  SQLFreeStmt  with return code 0 (SQL_SUCCESS)
        HSTMT               00E11CF8
        UWORD                        1 <SQL_DROP>


----------------------------------------------------------------------

>Comment By: Heikki Linnakangas (hlinnaka)
Date: 2015-01-22 09:23

Message:
This doesn't seem to be relevant anymore...

----------------------------------------------------------------------

Comment By: Hiroshi Inoue (hinoue)
Date: 2006-12-19 06:26

Message:
> What do you mean of "command sequence". Do you mean
> source code or SQL statements?

I meant the MFC API sequence in your source code.
Anyway I accepted another similar bug report and seem
to have found the cause.
MFC's CRecordset::GetFieldValue() seems to have a bug
in the Unicode version. There are 2 ways to correct it.

1. If the length of your text fields < 255, try to turn
   off the "Text as LongVarChar" option.
2. Please look at http://support.microsoft.com/kb/249803.

regards,
Hiroshi Inoue

----------------------------------------------------------------------

Comment By: Nobody (None)
Date: 2006-12-18 15:09

Message:
What do you mean of "command sequence". Do you mean source code or SQL statements?

For SQL statement, all I did is SELECT * FROM Inventory;

----------------------------------------------------------------------

Comment By: Hiroshi Inoue (hinoue)
Date: 2006-11-24 01:53

Message:
> I use MFC (suppose to be 8.0 on VisualStudio 2005)
> CDatabase and CRecordset to retrieve data from a postgres
> database. When the ODBC driver retrieve the data field
> type text that contain only 1 letter, CDBException is
> raised with return code is 100

Could you show me the main part (command sequence) of
your program ?

regards,
Hiroshi Inoue

----------------------------------------------------------------------

You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000790&group_id=1000125


pgsql-odbc by date:

Previous
From:
Date:
Subject: [psqlodbc-Bugs][1010508] win64.mak for psqlODBC on winxp 64bit
Next
From:
Date:
Subject: [psqlodbc-Bugs][1002767] Fatal exception error after running some queries