Declare/Fetch with For Update - Mailing list pgsql-odbc

From alexandre :: aldeia digital
Subject Declare/Fetch with For Update
Date
Msg-id 4390.200.225.214.1.1031667673.squirrel@webmail.ad2.com.br
Whole thread Raw
List pgsql-odbc
Hi,

I use psqlodbc-07_02_0002 and the query:

select x,y from ZZZ for update of ZZZ

Will be trasformed in :

declare SQL_CURxxx cursor for select x,y from ZZZ OF ZZZ

When I use declare/fetch, causing an error "near OF" because
the supress of 'for update'.
The ODBC driver may be bypass the use of declare/fetch when
the select have the 'for update' clause (or others wich update
rows), or I miss something ?
I need the 'for update', but the optimization of declare/fetch
are incredible in other parts of my application.

Thank´s all

Alexandre




pgsql-odbc by date:

Previous
From: mlw
Date:
Subject: Re: Accessing PGSQL
Next
From: Chris Gamache
Date:
Subject: PostgreSQL+ (Beta) and Active Server Pages with @TRANSACTION=REQUIRED