Обсуждение: 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 > >. > > >