Hello,
I've been working with ADO for a little while, and I found that the
Recordset's Bookmark property acts as a unique id for each record, and
that's just what I need for my current project. But I found this on MSDN:
by Iván Vega River » Sat, 19 Aug 2000 04:00:00
I've been working with ADO for a little while, and I found that the
Recordset's Bookmark property acts as a unique id for each record, and
that's just what I need for my current project. But I found this on MSDN:
by Iván Vega River » Sat, 19 Aug 2000 04:00:00
Well, as I was saying, here is what MSDN says:
"Bookmarks are available only in Recordset objects that support bookmark
functionality."
And I was afraid...Murphy says: If anything can go wrong, it will...
And indeed, my recordset doesn't supports that functionality...
Anyone knows what kind of recorsets have this functionality, or how can I
enable it?
Thanks in advance.
Quote:> Hello,
> I've been working with ADO for a little while, and I found that the
> Recordset's Bookmark property acts as a unique id for each record, and
> that's just what I need for my current project. But I found this on MSDN:
by Iván Vega River » Sat, 19 Aug 2000 04:00:00
Ctrl+Enter I mean... ok, ok, back to workQuote:> Hehe, I accidentally pressed Alt+S...At least I learned I new shortcut
> Well, as I was saying, here is what MSDN says:
> "Bookmarks are available only in Recordset objects that support bookmark
> functionality."
> And I was afraid...Murphy says: If anything can go wrong, it will...
> And indeed, my recordset doesn't supports that functionality...
> Anyone knows what kind of recorsets have this functionality, or how can I
> enable it?
> Thanks in advance.
> > Hello,
> > I've been working with ADO for a little while, and I found that the
> > Recordset's Bookmark property acts as a unique id for each record, and
> > that's just what I need for my current project. But I found this on
MSDN:
by Constantin Dor » Sat, 19 Aug 2000 04:00:00
Use adOpenStatic or adOpenKeyset cursor type
when you open the recordset.
by Iván Vega River » Sat, 19 Aug 2000 04:00:00
you'd never believe how useful are these groups!
Quote:> Use adOpenStatic or adOpenKeyset cursor type
> when you open the recordset.
1. RDO bookmarks vs DAO bookmarks
--------------0B3F6D636C93B262299F0EB8
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Can someone explain what the difference between this DAO/Access code:
dtaReq.Recordset.MoveLast
NoOfItems = dtaReq.Recordset.RecordCount
dtaReq.Recordset.MoveFirst
For z = 0 To NoOfItems - 1
DBGrid1.SelBookmarks.Add dtaReq.Recordset.Bookmark
dtaReq.Recordset.MoveNext
Next z
and this RDO/SQL Code is?
rdcRequisition.Resultset.MoveLast
NoOfItems = rdcRequisition.Resultset.RowCount
rdcRequisition.Resultset.MoveFirst
For z = 0 To NoOfItems - 1
DBGrid1.SelBookmarks.Add rdcRequisition.Resultset.Bookmark
rdcRequisition.Resultset.MoveNext
Next z
I am moving my DAO/Access VB 4 app to SQL 6.5 and this piece of code is
from a Select All button on one of my forms. With DAO is works fine,
with RDO it does not select the rows at all.
I have checked the Bookmarkable property which is TRUE for all the
rows. So why doesn't this work for with the RDC control?
Any help woudl be much appreciated
Julia
--------------0B3F6D636C93B262299F0EB8
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit
<HTML>
<B>Can someone explain what the difference between this DAO/Access code:</B>
<BR>dtaReq.Recordset.MoveLast
<BR>NoOfItems = dtaReq.Recordset.RecordCount
<BR>dtaReq.Recordset.MoveFirst
<P>For z = 0 To NoOfItems - 1
<BR> DBGrid1.SelBookmarks.Add dtaReq.Recordset.Bookmark
<BR> dtaReq.Recordset.MoveNext
<BR>Next z
<P><B>and this RDO/SQL Code is?</B>
<BR>rdcRequisition.Resultset.MoveLast
<BR>NoOfItems = rdcRequisition.Resultset.RowCount
<BR>rdcRequisition.Resultset.MoveFirst
<P>For z = 0 To NoOfItems - 1
<BR> DBGrid1.SelBookmarks.Add rdcRequisition.Resultset.Bookmark
rdcRequisition.Resultset.MoveNext
<BR>Next z
<P><B>I am moving my DAO/Access VB 4 app to SQL 6.5 and this piece of code
is from a Select All button on one of my forms. With DAO is
works fine, with RDO it does not select the rows at all.</B>
<BR><B>I have checked the Bookmarkable property which is TRUE for all the
rows. So why doesn't this work for with the RDC control?</B>
<BR><B>Any help woudl be much appreciated</B>
<BR><B>Julia</B></HTML>
--------------0B3F6D636C93B262299F0EB8--
2. Urgent: Oracle person needed
3. DrillThrough enabled, PivotTable enable drilldown is not
5. How to enable write-enable?
6. Question about the sqlexec process and forks
7. Adding job with enabled=1 but not enabled
8. Connectivity method - what is BEST
9. to --enable-locale or not to --enable-locale?
12. Bookmark?how to?