StatementHandle will be free automatically after you excute a update (delete) query that return 0 row affect.

Поиск
Список
Период
Сортировка
От freeman
Тема StatementHandle will be free automatically after you excute a update (delete) query that return 0 row affect.
Дата
Msg-id 0HQD002IGR9ANE@mmp3.fz.fj.cn
обсуждение исходный текст
Список pgsql-odbc
SERVER: MANDRIKE 8.1+POSTGRESQL 7.4
CLENT : PWIN98+PSQLODBC7.03.02
TEST TOOL:  ODBC TEST

If ODBCVER <>3.0 , StatementHandle will be free automatically after you excute a update (delete) query that return 0
rowaffect. 

EXAMPLE 1: (ERROR? StatementHandle will be free automatically after SQLExecdirect )
----------------------------------------------------------------------------
Full Connect(Default)

    Successfully connected to DSN 'PostgreSQL30'.
SQLExecDirect:
                In:                hstmt = 0x00C00748,
                                        szSqlStr = "DELETE FROM GUEST WHERE 1=2", cbSqlStr = -3
                Return:    SQL_NO_DATA_FOUND=100
SQLNumResultCols:
                In:                StatementHandle = 0x00C00748, ColumnCountPtr = 0x004B85E0
                Return:    SQL_ERROR=-1
                Out:            *ColumnCountPtr = <unmodified>
                stmt:        szSqlState = "S1010", *pfNativeError = 0, *pcbErrorMsg = 56
                                        szErrorMsg = "[Microsoft][ODBC Driver Manager] Function sequence error"
------------------------------------------------------------------------------


EXAMPLE 2:  (OK)
-------------------------------------------------------------------------------
Full Connect(Default)

    Env. Attr. SQL_ATTR_ODBC_VERSION set to SQL_OV_ODBC3

    Successfully connected to DSN 'PostgreSQL30'.
SQLExecDirect:
                In:                hstmt = 0x00C00748,
                                        szSqlStr = "DELETE FROM GUEST WHERE 1=2", cbSqlStr = -3
                Return:    SQL_NO_DATA_FOUND=100
SQLNumResultCols:
                In:                StatementHandle = 0x00C00748, ColumnCountPtr = 0x004B85E0
                Return:    SQL_SUCCESS=0
                Out:            *ColumnCountPtr = 0
--------------------------------------------------------------------------------




В списке pgsql-odbc по дате отправления:

Предыдущее
От: freeman
Дата:
Сообщение: bug: DELETE OR UPDATE EMPTY TABLE in VFP
Следующее
От: "Miguel Juan"
Дата:
Сообщение: Re: get last oid