Skip site navigation (1) Skip section navigation (2)

Declare/Fetch with For Update

From: "alexandre :: aldeia digital" <alepaes(at)aldeiadigital(dot)com(dot)br>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: Declare/Fetch with For Update
Date: 2002-09-10 14:21:13
Message-ID: 4390.200.225.214.1.1031667673.squirrel@webmail.ad2.com.br (view raw or flat)
Thread:
Lists: 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




Responses

pgsql-odbc by date

Next:From: Chris GamacheDate: 2002-09-10 16:32:06
Subject: PostgreSQL+ (Beta) and Active Server Pages with @TRANSACTION=REQUIRED
Previous:From: Amy ChuDate: 2002-09-10 13:34:07
Subject: Inquiry From Form [pgsql]

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group