Re: ForwardOnly ?

--- Petr Odlo�il <odlozil@trakceol.cz> wrote:
> I din't set this option forward cursors only and I
> even can't find it to
> check the state of it. I'm using ODBC driver for

My understanding is that, if you want an updateable
cursor, it has to be forward only.  This is a
limitation of the PostgreSQL ODBC driver.  I believe
that the "updatable cursors" driver setting refers to
this.  But I'm only working from memory here; I could
not find a reference to this when I looked.  Someone
else please correct me as necessary.

> windows and I looked to
> the system registry to the ODBC.INI section and
> there was nothing
> simillar. Is somewhere a guide for this detailed
> ODBC driver configuration ?

The best information I am aware of is here:
http://gborg.postgresql.org/project/psqlodbc/genpage.php?doc-config

>
> thanks
>
> Petr
>
> >>Hello,
> >>
> >>  I'm using some Control and Visualization tool
> ControlWeb for my
> >>aplication and saving information into the
> Postgres database through the
> >>ODBC driver.
> >>SQL queries works fine, but when I was to move
> through the open set of
> >>records using the procedures of the Control Web
> >>a did get following message :
> >>  The fetch type for PGAPI_ExtendedFetch isn't
> allowed with ForwardOnly
> >>cursor
> >>
> >>is there any help about it ?
> >
> >
> > Do you have set forward cursors only in ODBC
> configuration ?
> > I can use it with success, but I don't know about
> ControlWeb.
> >
> > Lothar
> >
>
>
> thanks a lot
> >>
> >>Petr
> >>
> >>
> >>--
> >>Odchozi zprava neobsahuje viry.
> >>Zkontrolovano Antivirovym systemem AVG.
> >>Verze: 7.0.308 / Virova baze: 266.10.2 - datum
> vydani: 21.4.2005
> >>
> >>
> >>---------------------------(end of
> broadcast)---------------------------
> >>TIP 4: Don't 'kill -9' the postmaster
> >>
> >
> >
> >
> > --
> > Lothar Behrens        www.lollisoft.de
> > Rosmarinstr 3        My public project:
> > 40235 D�sseldorf
> http://sourceforge.net/projects/lbdmf
> >
> >
> >
> >
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the
> unregister command
> >     (send "unregister YourEmailAddressHere" to
> majordomo@postgresql.org)
> >
> >
>
>
> --
> Odchoz� zpr�va neobsahuje viry.
> Zkontrolov�no Antivirov�m syst�mem AVG.
> Verze: 7.0.308 / Virov� b�ze: 266.10.2 - datum
> vyd�n�: 21.4.2005
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please
> send an appropriate
>       subscribe-nomail command to
> majordomo@postgresql.org so that your
>       message can get through to the mailing list
> cleanly
>

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com