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

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 (view raw or flat)
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 :-)


pgsql-odbc by date

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

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