Thread: Declare/Fetch with For Update

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

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@postgresql.org
>
>.
>
>
>