UPDATE ... WHERE CURRENT OF ... problem

From: "Lothar Behrens" <lothar(dot)behrens(at)lollisoft(dot)de>
To: pgsql-odbc(at)postgresql(dot)org
Subject: UPDATE ... WHERE CURRENT OF ... problem
Date: 2004-11-09 07:16:02
Message-ID: 200411090716.iA97G2C04808@jedi.behrens.de
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi,

I tried to avoid the problem when deleting rows with
the update statement with current of.

This gives me an illegal cursor state. Query and error:

update Kunden set deleted = 1 where CURRENT OF SQL_CUR00F110E0
SQLExecDirect(). [Microsoft][ODBC Driver Manager] Invalid cursor
state, SQLSTATE
=24000

I have tried also this: 'SQL_CUR00F110E0' in the query.

Am I missing something ?

Thanks

Lothar

---- My home: www.lollisoft.de -----------------------------
Lothar Behrens | Independent: lothar(dot)behrens(at)gmx(dot)de
Rosmarinstr 3 | My public project:
40235 Düsseldorf | http://sourceforge.net/projects/lbdmf
| -> Need comments, please visit :-)

Browse pgsql-odbc by date

  From Date Subject
Next Message Dave Page 2004-11-09 08:33:05 Re: 08.00.0002 useless :-)
Previous Message Gary Doades 2004-11-08 22:29:49 ODBC Driver stability