PostGreSql ODBC driver and Powerbuilder 7.0.3 problem
От | Laurent Savary |
---|---|
Тема | PostGreSql ODBC driver and Powerbuilder 7.0.3 problem |
Дата | |
Msg-id | afcfo1$1nce$1@news.hub.org обсуждение исходный текст |
Список | pgsql-general |
Hi everybody, I have the following problem with PostGreSql version 7.2.1 (on a Linux Redhat 7.2) and Powerbuilder 7.0.3 (build 10108) when I use the ODBC driver (7.02.00.01) for adding new row on a table which have (in the update properties) an identity column. The insert's command seems ok, but in the log file I have some strange caracters : pb70 1d1-17c ENTER SQLExecDirect HSTMT 0BB32E88 UCHAR * 0x04E80EA0 [ -3] "INSERT INTO datetest2 ( dat_descr ) VALUES ( 'toto' )\ 0" SDWORD -3 pb70 1d1-17c EXIT SQLExecDirect with return code 0 (SQL_SUCCESS) HSTMT 0BB32E88 UCHAR * 0x04E80EA0 [ -3] "INSERT INTO datetest2 ( dat_descr ) VALUES ( 'toto' )\ 0" SDWORD -3 pb70 1d1-17c ENTER SQLAllocStmt HDBC 0BB31908 HSTMT * 0012E8F0 pb70 1d1-17c EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS) HDBC 0BB31908 HSTMT * 0x0012E8F0 ( 0x0bb338c0) pb70 1d1-17c ENTER SQLExecDirect HSTMT 0BB338C0 UCHAR * 0x0012E93C [ -3] "0\ 0" SDWORD -3 pb70 1d1-17c EXIT SQLExecDirect with return code -1 (SQL_ERROR) HSTMT 0BB338C0 UCHAR * 0x0012E93C [ -3] "0\ 0" SDWORD -3 DIAG [S1000] ERROR: parser: parse error at or near "0" (7) pb70 1d1-17c ENTER SQLFreeStmt HSTMT 0BB338C0 UWORD 1 <SQL_DROP> pb70 1d1-17c EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS) HSTMT 0BB338C0 UWORD 1 <SQL_DROP> pb70 1d1-17c ENTER SQLTransact HENV 0BB341A0 HDBC 0BB31970 UWORD 0 <SQL_COMMIT> With Dw which haven't identity column specified on update properties there are no problem. Does anybody have the same problem? Thanks in advance -- Laurent Savary SA Medial Note : remove no_spam for reply
В списке pgsql-general по дате отправления: