Обсуждение: UPDATE ... WHERE CURRENT OF ... problem

Поиск
Список
Период
Сортировка

UPDATE ... WHERE CURRENT OF ... problem

От
"Lothar Behrens"
Дата:
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.behrens@gmx.de
Rosmarinstr 3     | My public project:
40235 Düsseldorf  |  http://sourceforge.net/projects/lbdmf
                  |  -> Need comments, please visit :-)