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

Re: Declare/Fetch with For Update

From: lee johnson <lee(at)imyourhandiman(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Declare/Fetch with For Update
Date: 2002-09-10 16:35:30
Message-ID: 3D7E1F52.4050401@imyourhandiman.com (view raw or flat)
Thread:
Lists: pgsql-odbc
was talking with someone online and they mentioned getting ODBC for 
msaccess and them exporting my database with that and importing ( with 
postgres-odbc installed) them somehow into postgres via pgaccess?????

that would be loverly if possible but are there ( assuming this is possible)
special directions to be aware of to pull this off??

thx
lee


alexandre :: aldeia digital wrote:

>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
>
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
>.
>
>  
>




In response to

pgsql-odbc by date

Next:From: lee johnsonDate: 2002-09-10 16:42:50
Subject: import msaccess stuff into pgccess-standalone desktop
Previous:From: Chris GamacheDate: 2002-09-10 16:32:06
Subject: PostgreSQL+ (Beta) and Active Server Pages with @TRANSACTION=REQUIRED

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