OpenEuphoria

RE: ODBC

• Posted by Matt Lewis <matthewwalkerlewis at yahoo.com> Oct 08, 2003
• 497 views

> From: George Walters [mailto:gwalters at sc.rr.com] 
> 
> Matt, your doc shows an argument to moveToRecord of 
> SQL_FETCH_BOOKMARK but it was apparently overlooked (var not 
> defined). Do you know it's value.... maybe 0 or 7? I'm 
> assuming that this would return your current position in the cursor?

I'm not sure.  I'll have to dig that up, but 7 would be my guess.  Actually,
it looks a bit more complicated than that.  You can set bookmarks, and then
go back to them later, but I haven't figured out how to do this yet.

> ...is there a way to position in  a cursor other than by a 
> "record number"?.... for example find partNbr 1234 in the cursor set?

Not that I'm aware of.

> ...It would be nice (if MS has such a
> function) to remove it from the cursor rather than reloading 
> the data, particularly if it's a larger file.

It looks like you can do this with calls to SQLSetPos().  I'll look at
adding support for this for the next release.

Matt Lewis