UPDATE with data at exec and CURRENT OF question

From: "lothar(dot)behrens(at)lollisoft(dot)de" <lothar(dot)behrens(at)lollisoft(dot)de>
To: pgsql-odbc(at)postgresql(dot)org
Subject: UPDATE with data at exec and CURRENT OF question
Date: 2007-08-08 17:14:04
Message-ID: 1186593244.173056.317630@q75g2000hsh.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Paul Lambert 2007-08-08 22:25:41 ODBC driver adding extra characters to table names.
Previous Message lothar.behrens@lollisoft.de 2007-08-08 14:24:52 SetPos with data_at_exec not yet supported ?