Hi,

I've create a stored procedure on a solidDb which can return multiple
rows.
When it returns 1 row everything is ok, but if it returns more than 1
rows I keep getting "SOLID Procedure Error 23519". Wich stats I use
FETCH_PREVIOUS, bus that is not the case.

Can any one tell me what's wrong.

kind regards,
Diederick Raven

Below is my odbc datasource trace:

********* 1 ROW RESULT: **********

VelocityPortal 1660-1830 ENTER SQLAllocHandle
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 0x0CFF1968
SQLHANDLE * 0x06B6D658

VelocityPortal 1660-1830 EXIT SQLAllocHandle with return code 0
(SQL_SUCCESS)
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 0x0CFF1968
SQLHANDLE * 0x06B6D658 ( 0x0D003590)

VelocityPortal 1660-1830 ENTER SQLPrepareW
HSTMT 0x0D003590
WCHAR * 0x06BB83F8 [ -3] "call vs_get_event(?,?,?)\
0"
SDWORD -3

VelocityPortal 1660-1830 EXIT SQLPrepareW with return code 0
(SQL_SUCCESS)
HSTMT 0x0D003590
WCHAR * 0x06BB83F8 [ -3] "call vs_get_event(?,?,?)\
0"
SDWORD -3

VelocityPortal 1660-1830 ENTER SQLBindCol
HSTMT 0x0D003590
UWORD 1
SWORD 5 <SQL_C_SHORT>
PTR 0x06BE3C70
SQLLEN 0
SQLLEN * 0x00000000

VelocityPortal 1660-1830 EXIT SQLBindCol with return code 0
(SQL_SUCCESS)
HSTMT 0x0D003590
UWORD 1
SWORD 5 <SQL_C_SHORT>
PTR 0x06BE3C70
SQLLEN 0
SQLLEN * 0x00000000

VelocityPortal 1660-1830 ENTER SQLBindCol
HSTMT 0x0D003590
UWORD 2
SWORD 4 <SQL_C_LONG>
PTR 0x06BE3C74
SQLLEN 0
SQLLEN * 0x00000000

VelocityPortal 1660-1830 EXIT SQLBindCol with return code 0
(SQL_SUCCESS)
HSTMT 0x0D003590
UWORD 2
SWORD 4 <SQL_C_LONG>
PTR 0x06BE3C74
SQLLEN 0
SQLLEN * 0x00000000

VelocityPortal 1660-1830 ENTER SQLBindCol
HSTMT 0x0D003590
UWORD 3
SWORD -25 <SQL_C_SBIGINT>
PTR 0x06BE3C78
SQLLEN 0
SQLLEN * 0x00000000

VelocityPortal 1660-1830 EXIT SQLBindCol with return code 0
(SQL_SUCCESS)
HSTMT 0x0D003590
UWORD 3
SWORD -25 <SQL_C_SBIGINT>
PTR 0x06BE3C78
SQLLEN 0
SQLLEN * 0x00000000

VelocityPortal 1660-1830 ENTER SQLBindParameter
HSTMT 0x0D003590
UWORD 1
SWORD 1 <SQL_PARAM_INPUT>
SWORD -25 <SQL_C_SBIGINT>
SWORD -5 <SQL_BIGINT>
SQLULEN 8
SWORD 0
PTR 0x06C219B8
SQLLEN 0
SQLLEN * 0x00000000

VelocityPortal 1660-1830 EXIT SQLBindParameter with return code 0
(SQL_SUCCESS)
HSTMT 0x0D003590
UWORD 1
SWORD 1 <SQL_PARAM_INPUT>
SWORD -25 <SQL_C_SBIGINT>
SWORD -5 <SQL_BIGINT>
SQLULEN 8
SWORD 0
PTR 0x06C219B8
SQLLEN 0
SQLLEN * 0x00000000

VelocityPortal 1660-1830 ENTER SQLBindParameter
HSTMT 0x0D003590
UWORD 2
SWORD 1 <SQL_PARAM_INPUT>
SWORD -25 <SQL_C_SBIGINT>
SWORD -5 <SQL_BIGINT>
SQLULEN 8
SWORD 0
PTR 0x06C219C0
SQLLEN 0
SQLLEN * 0x00000000

VelocityPortal 1660-1830 EXIT SQLBindParameter with return code 0
(SQL_SUCCESS)
HSTMT 0x0D003590
UWORD 2
SWORD 1 <SQL_PARAM_INPUT>
SWORD -25 <SQL_C_SBIGINT>
SWORD -5 <SQL_BIGINT>
SQLULEN 8
SWORD 0
PTR 0x06C219C0
SQLLEN 0
SQLLEN * 0x00000000

VelocityPortal 1660-1830 ENTER SQLBindParameter
HSTMT 0x0D003590
UWORD 3
SWORD 1 <SQL_PARAM_INPUT>
SWORD -17 <SQL_C_USHORT>
SWORD 5 <SQL_SMALLINT>
SQLULEN 2
SWORD 0
PTR 0x06C219C8
SQLLEN 0
SQLLEN * 0x00000000

VelocityPortal 1660-1830 EXIT SQLBindParameter with return code 0
(SQL_SUCCESS)
HSTMT 0x0D003590
UWORD 3
SWORD 1 <SQL_PARAM_INPUT>
SWORD -17 <SQL_C_USHORT>
SWORD 5 <SQL_SMALLINT>
SQLULEN 2
SWORD 0
PTR 0x06C219C8
SQLLEN 0
SQLLEN * 0x00000000

VelocityPortal 1660-1830 ENTER SQLSetStmtAttrW
SQLHSTMT 0x0D003590
SQLINTEGER 27 <SQL_ATTR_ROW_ARRAY_SIZE>
SQLPOINTER 100
SQLINTEGER 0

VelocityPortal 1660-1830 EXIT SQLSetStmtAttrW with return code 0
(SQL_SUCCESS)
SQLHSTMT 0x0D003590
SQLINTEGER 27 <SQL_ATTR_ROW_ARRAY_SIZE>
SQLPOINTER 100
SQLINTEGER 0

VelocityPortal 1660-1830 ENTER SQLSetStmtAttrW
SQLHSTMT 0x0D003590
SQLINTEGER 5 <SQL_ATTR_ROW_BIND_TYPE>
SQLPOINTER 16 <unknown>
SQLINTEGER 0

VelocityPortal 1660-1830 EXIT SQLSetStmtAttrW with return code 0
(SQL_SUCCESS)
SQLHSTMT 0x0D003590
SQLINTEGER 5 <SQL_ATTR_ROW_BIND_TYPE>
SQLPOINTER 16 <unknown>
SQLINTEGER 0

VelocityPortal 1660-1830 ENTER SQLSetStmtAttrW
SQLHSTMT 0x0D003590
SQLINTEGER 26 <SQL_ATTR_ROWS_FETCHED_PTR>
SQLPOINTER 0x06B51F50
SQLINTEGER 0

VelocityPortal 1660-1830 EXIT SQLSetStmtAttrW with return code 0
(SQL_SUCCESS)
SQLHSTMT 0x0D003590
SQLINTEGER 26 <SQL_ATTR_ROWS_FETCHED_PTR>
SQLPOINTER 0x06B51F50
SQLINTEGER 0

VelocityPortal 1660-1830 ENTER SQLSetStmtAttrW
SQLHSTMT 0x0D003590
SQLINTEGER 22 <SQL_ATTR_PARAMSET_SIZE>
SQLPOINTER 1
SQLINTEGER 0

VelocityPortal 1660-1830 EXIT SQLSetStmtAttrW with return code 0
(SQL_SUCCESS)
SQLHSTMT 0x0D003590
SQLINTEGER 22 <SQL_ATTR_PARAMSET_SIZE>
SQLPOINTER 1
SQLINTEGER 0

VelocityPortal 1660-1830 ENTER SQLSetStmtAttrW
SQLHSTMT 0x0D003590
SQLINTEGER 18 <SQL_ATTR_PARAM_BIND_TYPE>
SQLPOINTER 18 <unknown>
SQLINTEGER 0

VelocityPortal 1660-1830 EXIT SQLSetStmtAttrW with return code 0
(SQL_SUCCESS)
SQLHSTMT 0x0D003590
SQLINTEGER 18 <SQL_ATTR_PARAM_BIND_TYPE>
SQLPOINTER 18 <unknown>
SQLINTEGER 0

VelocityPortal 1660-1830 ENTER SQLSetStmtAttrW
SQLHSTMT 0x0D003590
SQLINTEGER 21 <SQL_ATTR_PARAMS_PROCESSED_PTR>
SQLPOINTER 0x06B51FA8
SQLINTEGER 0

VelocityPortal 1660-1830 EXIT SQLSetStmtAttrW with return code 0
(SQL_SUCCESS)
SQLHSTMT 0x0D003590
SQLINTEGER 21 <SQL_ATTR_PARAMS_PROCESSED_PTR>
SQLPOINTER 0x06B51FA8
SQLINTEGER 0

VelocityPortal 1660-ec0 ENTER SQLExecute
HSTMT 0x0D003590

VelocityPortal 1660-ec0 EXIT SQLExecute with return code 0
(SQL_SUCCESS)
HSTMT 0x0D003590

VelocityPortal 1660-ec0 ENTER SQLFetchScroll
SQLHSTMT 0x0D003590
SQLSMALLINT 1 <SQL_FETCH_NEXT>
SQLLEN 0

VelocityPortal 1660-ec0 EXIT SQLFetchScroll with return code 0
(SQL_SUCCESS)
SQLHSTMT 0x0D003590
SQLSMALLINT 1 <SQL_FETCH_NEXT>
SQLLEN 0

VelocityPortal 1660-ec0 ENTER SQLFetchScroll
SQLHSTMT 0x0D003590
SQLSMALLINT 1 <SQL_FETCH_NEXT>
SQLLEN 0

VelocityPortal 1660-ec0 EXIT SQLFetchScroll with return code 100
(SQL_NO_DATA_FOUND)
SQLHSTMT 0x0D003590
SQLSMALLINT 1 <SQL_FETCH_NEXT>
SQLLEN 0

VelocityPortal 1660-ec0 ENTER SQLGetDiagRecW
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 0x0D003590
SQLSMALLINT 1
SQLWCHAR * 0x0FFBF688
SQLINTEGER * 0x0FFBF67C
SQLWCHAR * 0x0FFBF274
SQLSMALLINT 512
SQLSMALLINT * 0x0FFBF268

VelocityPortal 1660-ec0 EXIT SQLGetDiagRecW with return code 100
(SQL_NO_DATA_FOUND)
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 0x0D003590
SQLSMALLINT 1
SQLWCHAR * 0x0FFBF688
SQLINTEGER * 0x0FFBF67C
SQLWCHAR * 0x0FFBF274
SQLSMALLINT 512
SQLSMALLINT * 0x0FFBF268

VelocityPortal 1660-ec0 ENTER SQLFreeHandle
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 0x0D003590

VelocityPortal 1660-ec0 EXIT SQLFreeHandle with return code 0
(SQL_SUCCESS)
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 0x0D003590



*********** 2 ROWS RESULT:**************

VelocityPortal 1660-1830 ENTER SQLAllocHandle
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 0x0CFEE198
SQLHANDLE * 0x06B56D18

VelocityPortal 1660-1830 EXIT SQLAllocHandle with return code 0
(SQL_SUCCESS)
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 0x0CFEE198
SQLHANDLE * 0x06B56D18 ( 0x0D003590)

VelocityPortal 1660-1830 ENTER SQLPrepareW
HSTMT 0x0D003590
WCHAR * 0x06BEAE78 [ -3] "call vs_get_event(?,?,?)\
0"
SDWORD -3

VelocityPortal 1660-1830 EXIT SQLPrepareW with return code 0
(SQL_SUCCESS)
HSTMT 0x0D003590
WCHAR * 0x06BEAE78 [ -3] "call vs_get_event(?,?,?)\
0"
SDWORD -3

VelocityPortal 1660-1830 ENTER SQLBindCol
HSTMT 0x0D003590
UWORD 1
SWORD 5 <SQL_C_SHORT>
PTR 0x06BE5670
SQLLEN 0
SQLLEN * 0x00000000

VelocityPortal 1660-1830 EXIT SQLBindCol with return code 0
(SQL_SUCCESS)
HSTMT 0x0D003590
UWORD 1
SWORD 5 <SQL_C_SHORT>
PTR 0x06BE5670
SQLLEN 0
SQLLEN * 0x00000000

VelocityPortal 1660-1830 ENTER SQLBindCol
HSTMT 0x0D003590
UWORD 2
SWORD 4 <SQL_C_LONG>
PTR 0x06BE5674
SQLLEN 0
SQLLEN * 0x00000000

VelocityPortal 1660-1830 EXIT SQLBindCol with return code 0
(SQL_SUCCESS)
HSTMT 0x0D003590
UWORD 2
SWORD 4 <SQL_C_LONG>
PTR 0x06BE5674
SQLLEN 0
SQLLEN * 0x00000000

VelocityPortal 1660-1830 ENTER SQLBindCol
HSTMT 0x0D003590
UWORD 3
SWORD -25 <SQL_C_SBIGINT>
PTR 0x06BE5678
SQLLEN 0
SQLLEN * 0x00000000

VelocityPortal 1660-1830 EXIT SQLBindCol with return code 0
(SQL_SUCCESS)
HSTMT 0x0D003590
UWORD 3
SWORD -25 <SQL_C_SBIGINT>
PTR 0x06BE5678
SQLLEN 0
SQLLEN * 0x00000000

VelocityPortal 1660-1830 ENTER SQLBindParameter
HSTMT 0x0D003590
UWORD 1
SWORD 1 <SQL_PARAM_INPUT>
SWORD -25 <SQL_C_SBIGINT>
SWORD -5 <SQL_BIGINT>
SQLULEN 8
SWORD 0
PTR 0x06B6C5C8
SQLLEN 0
SQLLEN * 0x00000000

VelocityPortal 1660-1830 EXIT SQLBindParameter with return code 0
(SQL_SUCCESS)
HSTMT 0x0D003590
UWORD 1
SWORD 1 <SQL_PARAM_INPUT>
SWORD -25 <SQL_C_SBIGINT>
SWORD -5 <SQL_BIGINT>
SQLULEN 8
SWORD 0
PTR 0x06B6C5C8
SQLLEN 0
SQLLEN * 0x00000000

VelocityPortal 1660-1830 ENTER SQLBindParameter
HSTMT 0x0D003590
UWORD 2
SWORD 1 <SQL_PARAM_INPUT>
SWORD -25 <SQL_C_SBIGINT>
SWORD -5 <SQL_BIGINT>
SQLULEN 8
SWORD 0
PTR 0x06B6C5D0
SQLLEN 0
SQLLEN * 0x00000000

VelocityPortal 1660-1830 EXIT SQLBindParameter with return code 0
(SQL_SUCCESS)
HSTMT 0x0D003590
UWORD 2
SWORD 1 <SQL_PARAM_INPUT>
SWORD -25 <SQL_C_SBIGINT>
SWORD -5 <SQL_BIGINT>
SQLULEN 8
SWORD 0
PTR 0x06B6C5D0
SQLLEN 0
SQLLEN * 0x00000000

VelocityPortal 1660-1830 ENTER SQLBindParameter
HSTMT 0x0D003590
UWORD 3
SWORD 1 <SQL_PARAM_INPUT>
SWORD -17 <SQL_C_USHORT>
SWORD 5 <SQL_SMALLINT>
SQLULEN 2
SWORD 0
PTR 0x06B6C5D8
SQLLEN 0
SQLLEN * 0x00000000

VelocityPortal 1660-1830 EXIT SQLBindParameter with return code 0
(SQL_SUCCESS)
HSTMT 0x0D003590
UWORD 3
SWORD 1 <SQL_PARAM_INPUT>
SWORD -17 <SQL_C_USHORT>
SWORD 5 <SQL_SMALLINT>
SQLULEN 2
SWORD 0
PTR 0x06B6C5D8
SQLLEN 0
SQLLEN * 0x00000000

VelocityPortal 1660-1830 ENTER SQLSetStmtAttrW
SQLHSTMT 0x0D003590
SQLINTEGER 27 <SQL_ATTR_ROW_ARRAY_SIZE>
SQLPOINTER 100
SQLINTEGER 0

VelocityPortal 1660-1830 EXIT SQLSetStmtAttrW with return code 0
(SQL_SUCCESS)
SQLHSTMT 0x0D003590
SQLINTEGER 27 <SQL_ATTR_ROW_ARRAY_SIZE>
SQLPOINTER 100
SQLINTEGER 0

VelocityPortal 1660-1830 ENTER SQLSetStmtAttrW
SQLHSTMT 0x0D003590
SQLINTEGER 5 <SQL_ATTR_ROW_BIND_TYPE>
SQLPOINTER 16 <unknown>
SQLINTEGER 0

VelocityPortal 1660-1830 EXIT SQLSetStmtAttrW with return code 0
(SQL_SUCCESS)
SQLHSTMT 0x0D003590
SQLINTEGER 5 <SQL_ATTR_ROW_BIND_TYPE>
SQLPOINTER 16 <unknown>
SQLINTEGER 0

VelocityPortal 1660-1830 ENTER SQLSetStmtAttrW
SQLHSTMT 0x0D003590
SQLINTEGER 26 <SQL_ATTR_ROWS_FETCHED_PTR>
SQLPOINTER 0x06B513F8
SQLINTEGER 0

VelocityPortal 1660-1830 EXIT SQLSetStmtAttrW with return code 0
(SQL_SUCCESS)
SQLHSTMT 0x0D003590
SQLINTEGER 26 <SQL_ATTR_ROWS_FETCHED_PTR>
SQLPOINTER 0x06B513F8
SQLINTEGER 0

VelocityPortal 1660-1830 ENTER SQLSetStmtAttrW
SQLHSTMT 0x0D003590
SQLINTEGER 22 <SQL_ATTR_PARAMSET_SIZE>
SQLPOINTER 1
SQLINTEGER 0

VelocityPortal 1660-1830 EXIT SQLSetStmtAttrW with return code 0
(SQL_SUCCESS)
SQLHSTMT 0x0D003590
SQLINTEGER 22 <SQL_ATTR_PARAMSET_SIZE>
SQLPOINTER 1
SQLINTEGER 0

VelocityPortal 1660-1830 ENTER SQLSetStmtAttrW
SQLHSTMT 0x0D003590
SQLINTEGER 18 <SQL_ATTR_PARAM_BIND_TYPE>
SQLPOINTER 18 <unknown>
SQLINTEGER 0

VelocityPortal 1660-1830 EXIT SQLSetStmtAttrW with return code 0
(SQL_SUCCESS)
SQLHSTMT 0x0D003590
SQLINTEGER 18 <SQL_ATTR_PARAM_BIND_TYPE>
SQLPOINTER 18 <unknown>
SQLINTEGER 0

VelocityPortal 1660-1830 ENTER SQLSetStmtAttrW
SQLHSTMT 0x0D003590
SQLINTEGER 21 <SQL_ATTR_PARAMS_PROCESSED_PTR>
SQLPOINTER 0x06B51450
SQLINTEGER 0

VelocityPortal 1660-1830 EXIT SQLSetStmtAttrW with return code 0
(SQL_SUCCESS)
SQLHSTMT 0x0D003590
SQLINTEGER 21 <SQL_ATTR_PARAMS_PROCESSED_PTR>
SQLPOINTER 0x06B51450
SQLINTEGER 0

VelocityPortal 1660-13d4 ENTER SQLExecute
HSTMT 0x0D003590

VelocityPortal 1660-13d4 EXIT SQLExecute with return code 0
(SQL_SUCCESS)
HSTMT 0x0D003590

VelocityPortal 1660-13d4 ENTER SQLFetchScroll
SQLHSTMT 0x0D003590
SQLSMALLINT 1 <SQL_FETCH_NEXT>
SQLLEN 0

VelocityPortal 1660-13d4 EXIT SQLFetchScroll with return code -1
(SQL_ERROR)
SQLHSTMT 0x0D003590
SQLSMALLINT 1 <SQL_FETCH_NEXT>
SQLLEN 0

DIAG [HY000] SOLID Procedure Error 23519: Fetch previous is not
supported for procedures (23519)

VelocityPortal 1660-13d4 ENTER SQLGetDiagRecW
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 0x0D003590
SQLSMALLINT 1
SQLWCHAR * 0x0E1BF59C
SQLINTEGER * 0x0E1BF590
SQLWCHAR * 0x0E1BF188
SQLSMALLINT 512
SQLSMALLINT * 0x0E1BF17C

VelocityPortal 1660-13d4 EXIT SQLGetDiagRecW with return code 0
(SQL_SUCCESS)
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 0x0D003590
SQLSMALLINT 1
SQLWCHAR * 0x0E1BF59C [ 5] "HY000"
SQLINTEGER * 0x0E1BF590 (23519)
SQLWCHAR * 0x0E1BF188 [ 75] "SOLID Procedure Error
23519: Fetch previous is not supported for procedures"
SQLSMALLINT 512
SQLSMALLINT * 0x0E1BF17C (75)

VelocityPortal 1660-13d4 ENTER SQLFreeHandle
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 0x0D003590

VelocityPortal 1660-13d4 EXIT SQLFreeHandle with return code 0
(SQL_SUCCESS)
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 0x0D003590