T, Thanks for the response. I didn't give out ALL the information so that's probably why you're wondering why I'm doing what I'm doing. Actually the problem I'm having revolves around using Infragistics datagrid which relies on bookmarks quite a bit, especially when scrolling. The rs.Bookmark = 1 was just an example of what's being called. And, I believe bookmarks are variants, not strings. Hope that explains more.
Cheers, Jon "Tilmann Starke" <[EMAIL PROTECTED]> wrote in message 001501c2c76f$1a0fde20$7800a8c0@hosaka">news:001501c2c76f$1a0fde20$7800a8c0@hosaka... > Hi Jon, > > why do you use "rs.Bookmark = 1"? You could use rs.MoveFirst to go to > the first record. As far as I know the bookmarks are of string data > type. > > For example: > > Dim sBookmark as String ' declare some bookmark > > rs.MoveFirst ' go to first record > rs.MoveNext ' move some steps forward > rs.MoveNext > rs.MoveNext > rs.MoveNext > sBookmark = rs.Bookmark ' take current position into bookmark > rs.MoveFirst ' goto first record > rs.Bookmark = sBookmark ' this jumps to the bookmarked position > > Hope this helps, I did not try it, but it should work with any > bookmarkable database. > > Tilmann Starke > SOFTWORK GmbH > > Help to prevent global warming by writing cool software. > > > > -----Urspr�ngliche Nachricht----- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] Im Auftrag von JON > Gesendet: Mittwoch, 29. Januar 2003 05:52 > An: [EMAIL PROTECTED] > Betreff: A problem with ADO - ODBC and maybe bookmarks > > > Using ADO recordsets under VB here's the pertinent sequence of events as > I can discern it: > 0) I scroll through the recordset (count = 9) hitting EOF, going back to > a spot in the middle, doing MovePrevious until BOF is true. Eveything > seems fine. > 1) The recordset hits BOF = true. > 2) rs.BookMark = 1 (this moves it to the first record in the recordset > and executes successfully, BOF = False, there's good values in the > recordset.) > 3) rs.MoveNext (this gets an error: -2147217887 Multiple-step OLE DB > operation generated errors. Check each OLE DB status value, if > available. No work was done.) > > I can't imagine why I get any error. Any clues? > > Does anybody also have any clues how I can check the various errors > generated by OLE DB in this environment? > > Thanks, > Jon > > > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
