How to use ODBC to find a record by key in a larger result set

I'm using SQL32.INC,SQLEXT32.INC etc for the first time. I have some code
working fine in a report style program and it's very fast. In Maintenance
programs, I need to find a specific record and/or scroll from there. I can
get the scrolling next and prior working ok and I can get the calling up a
single account ok but scrolling immediately after a single record rowset fin
d
only works if I issue another select statement for the entire file. Of cours
e
the first sqlfetch gets the first record and not the first record after the
one that was just on screen. In other words I need to know how to retain the
absolute row position in the file some way so my scrolling can start from
there.Briefly, you need to bind column 0 (the bookmark column). There are some
set up steps you need to take (Setting 'use bookmarks' values to ON, etc.)
I'm not sure how much experience you have, but you should be able to find
some useful information on http://msdn.microsoft.com by searching for "ODBC
BOOKMARK". For example, I found an interesting article at
http://msdn.microsoft.com/library/d...-us/odbc/htm/od
bcscrolling_by_bookmark.asp
| Thread-Topic: How to use ODBC to find a record by key in a larger result
set
| thread-index: AcW5Qb9KPSrQ97YTT32NMc+1qaZ1Iw==
| X-WBNR-Posting-Host: 70.61.11.50
| From: "examnotes" <BobMTenn@.discussions.microsoft.com>
| Subject: How to use ODBC to find a record by key in a larger result set
| Date: Wed, 14 Sep 2005 08:34:08 -0700
| Lines: 10
| Message-ID: <BFB597E8-F6B0-4541-8345-52B400B58E86@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.odbc
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.odbc:2708
| X-Tomcat-NG: microsoft.public.sqlserver.odbc
|
| I'm using SQL32.INC,SQLEXT32.INC etc for the first time. I have some code
| working fine in a report style program and it's very fast. In Maintenance
| programs, I need to find a specific record and/or scroll from there. I
can
| get the scrolling next and prior working ok and I can get the calling up
a
| single account ok but scrolling immediately after a single record rowset
find
| only works if I issue another select statement for the entire file. Of
course
| the first sqlfetch gets the first record and not the first record after
the
| one that was just on screen. In other words I need to know how to retain
the
| absolute row position in the file some way so my scrolling can start from
| there.
|