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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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.


Thanks for the reply Dmitriy. I'm still pretty new to low level ODBC so it could well be something simple like this.

The bit flags (from SQLGetInfo) say that the database supports updates and deletes from static cursors. I have the corresponding dynamic cursor bit flags, and they're all zero! Ie. no support for anything.

I'll see what the keyset ones are set to...



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

Relevant Pages