PostGreSql ODBC driver and Powerbuilder 7.0.3 problem

From: "Laurent Savary" <laurent_savary(at)no_spam(dot)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org, pgsql-odbc(at)postgresql(dot)org
Subject: PostGreSql ODBC driver and Powerbuilder 7.0.3 problem
Date: 2002-06-26 13:32:29
Message-ID: afcfo1$1nce$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Jorge Sarmiento 2002-06-26 13:39:04 Strange behaviour of SELECT ... IN
Previous Message Markus Wollny 2002-06-26 12:50:56 Still problems with memory swapping and server load