Skip site navigation (1) Skip section navigation (2)

SQLSetPos problem ?

From: "lothar(dot)behrens(at)lollisoft(dot)de" <lothar(dot)behrens(at)lollisoft(dot)de>
To: pgsql-odbc(at)postgresql(dot)org
Subject: SQLSetPos problem ?
Date: 2006-12-10 11:58:37
Message-ID: 1165751917.708138.93120@j72g2000cwa.googlegroups.com (view raw or flat)
Thread:
Lists: pgsql-odbc
Hi,

I am using unixodbc in the latest version and psqlodbc 07.03.0200.
Having many queries working
good in my application one gives me this error, when updating a row.

Any hints ?

Thanks, Lothar

[SQLSetPos]PGAPI_SetPos fOption=2 irow=1 lock=0 currt=-1
STATEMENT ERROR: func=PGAPI_SetPos, desc='', errnum=21, errmsg='Row
value out of range'
CONN ERROR: func=PGAPI_SetPos, desc='', errnum=0, errmsg='(NULL)'
[SQLError]**** PGAPI_Error: henv=0, hdbc=0 hstmt=170626352
**** PGAPI_StmtError: hstmt=170626352 <512>
SC_get_error: status = 21, msg = #Row value out of range#
             szSqlState = 'HY107',len=22, szError='Row value out of
range'
**** PGAPI_Error exit code=0
[SQLError]**** PGAPI_Error: henv=0, hdbc=0 hstmt=170626352
**** PGAPI_StmtError: hstmt=170626352 <512>
SC_Get_error returned nothing.
**** PGAPI_Error exit code=100


Responses

pgsql-odbc by date

Next:From: KarebacDate: 2006-12-10 12:22:25
Subject: Re: BEST odbc driver for windows MS Access
Previous:From: noreplyDate: 2006-12-08 12:38:31
Subject: [ psqlodbc-Bugs-1000797 ] Conn. created by ODBCCP32.DLL/SQLConfigDataSource doesn't take some parameters

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group