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
