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
|
Список | 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 по дате отправления: