UPDATE with data at exec and CURRENT OF question

Поиск
Список
Период
Сортировка
От lothar.behrens@lollisoft.de
Тема UPDATE with data at exec and CURRENT OF question
Дата
Msg-id 1186593244.173056.317630@q75g2000hsh.googlegroups.com
обсуждение исходный текст
Ответы Re: UPDATE with data at exec and CURRENT OF question  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-odbc
Hi,

after all my tries I ran into trouble with this statement:

UPDATE "Kontakte" set "Notiz" = ? WHERE CURRENT OF SQL_CUR0x1321f670

I see that my parameter has been passed. And the driver has build up
the query. But I do not understand, why
there is a syntax error near the 'OF' keyword.

Does PostgreSQL not support this syntax ?

Thanks, Lothar

Exec_with_parameters_resolved: copying statement params:
trans_status=1, len=68, stmt='UPDATE "Kontakte" set "Notiz" = ? WHERE
CURRENT OF SQL_CUR0x1321f670'
ResolveOneParam: from(fcType)=-2, to(fSqlType)=-4
SQL_VARBINARY: about to call convert_to_pgbinary, used = 4
convert_to_pgbinary: in[0] = 76, L
convert_to_pgbinary: in[1] = 97, a
convert_to_pgbinary: in[2] = 108, l
convert_to_pgbinary: in[3] = 97, a
convert_to_pgbinary: returning 4, out='Lala'
   stmt_with_params = 'UPDATE "Kontakte" set "Notiz" = 'Lala' WHERE
CURRENT OF SQL_CUR0x1321f670'
      it's NOT a select statement: stmt=321250656
send_query(): conn=25601024, query='UPDATE "Kontakte" set "Notiz" =
'Lala' WHERE CURRENT OF SQL_CUR0x1321f670'
send_query: done sending query


В списке pgsql-odbc по дате отправления:

Предыдущее
От: "lothar.behrens@lollisoft.de"
Дата:
Сообщение: SetPos with data_at_exec not yet supported ?
Следующее
От: Paul Lambert
Дата:
Сообщение: ODBC driver adding extra characters to table names.