Re: ForwardOnly ?

--- Petr Odloil <odlozil(at)trakceol(dot)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 Dsseldorf
> 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(at)postgresql(dot)org)
> >
> >
>
>
> --
> Odchoz zprva neobsahuje viry.
> Zkontrolovno Antivirovm systmem AVG.
> Verze: 7.0.308 / Virov bze: 266.10.2 - datum
> vydn: 21.4.2005
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please
> send an appropriate
> subscribe-nomail command to
> majordomo(at)postgresql(dot)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