Re: SQLSetPos returning HY106 "Fetch type out of range"??

Dmitriy Ivanov wrote: 
Hello Richard,
"Richard Marsden" <noreply@xxxxxxxxxxxxxxxxxx> wrote:

RM> Further to this, I've checked the cursor type:  it is static.
RM> |...snip...|

Are you sure that static cursors are intended for updating? I would
recommend to try key-set driven or dynamic ones.

Despite the false flags, I've just tried a keyset cursor. Interestingly the rest of my code works, but I'm still getting the HY106 'Fetch type out of range' error...


--
Richard Marsden
Winwaed Software Technology, http://www.winwaed.com
http://www.mapping-tools.com for MapPoint tools and add-ins
.

Relevant Pages

  • Re: SQLSetPos returning HY106 "Fetch type out of range"??
    ... Dmitriy Ivanov wrote: ... Are you sure that static cursors are intended for updating? ... recommend to try key-set driven or dynamic ones. ... The bit flags say that the database supports updates ...
    (microsoft.public.data.odbc)
  • Re: SQLSetPos returning HY106 "Fetch type out of range"??
    ... I've checked the cursor type: ... Are you sure that static cursors are intended for updating? ... recommend to try key-set driven or dynamic ones. ...
    (microsoft.public.data.odbc)
  • Re: Power Point
    ... this small programme can delete anything I would also recommend ... updating your anti virus and running a system scan since you got this ...
    (microsoft.public.windowsxp.general)
  • Hauppauge Nova T 500, MCE 2005 and XP SP3
    ... To anyone with one of these tuners, I'd recommend not updating to XP SP3 for ...
    (microsoft.public.windows.mediacenter)