使用rs.Bookmark导航到记录的ADP问题 [英] ADP issue with navigating to record using rs.Bookmark
问题描述
以下代码与标准MDB一起使用
到一个特定记录（当然还有DAO记录集）
但是它给了我一些问题在一个ADP我正在努力。
Dim rs作为ADODB.Recordset
设置rs = Me.RecordsetClone
rs.Find[ContractID] =" &安培; lngContractID
如果不是rs.EOF那么Me.Bookmark = rs.Bookmark
我必须在这里找到Heisenberb Uncertainty Principal，因为它
工作正常，而我观察系统 ...使用F8逐步完成
代码。但是，当我让代码运行它自己的
时，ADO记录集在EOF。
只要我创建一个人工暂停，通过单步执行，
记录集会被填充，但不会全速运行。
数据在SQL Server中。网络可以检索时间
这样做吗？在ADP中有没有不同的方式导航到记录
？
Danny J. Lesandrini
dl ********* @ hotmail.com
http://amazecreations.com/datafast
< blockquote>Danny J. Lesandrini < DL ********* @ hotmail.com>在新闻中写道：bt81vj
371s4
1
@ ID-82595.news.uni-berlin.de：
以下代码与标准MDB一起用于导航到特定记录（当然还有DAO记录集）
但是它给了我我正在研究ADP中的问题。
Dim rs As ADODB.Recordset
设置rs = Me.RecordsetClone
rs.Find" [ContractID] =" &安培; lngContractID
如果没有rs.EOF那么Me.Bookmark = rs.Bookmark
我必须在这里找到Heisenberb Uncertainty Principal，因为它在我观察系统时工作正常; ...使用F8逐步完成代码。但是，当我让代码运行它自己的时候，ADO记录集就在EOF上。
只要我通过单步创建一个人工暂停，
记录集会被填充，但不会全速运行。
数据在SQL Server中。网络可以检索时间吗？在ADP中有没有不同的方式导航到记录？
Danny J. Lesandrini
dl ********* @ hotmail.com
http://amazecreations.com/datafast
通常我们在
" Finding"在ADO但我不知道这与你在这里报告的内容有什么关系。
-
莱尔
（电子邮件参考 http://ffdba.com /contacts.htm ）
The following code works with a standard MDB to navigate
to a particluar record (with a DAO recordset, of course)
but it''s giving me problems in an ADP I''m working on.
Dim rs As ADODB.Recordset
Set rs = Me.RecordsetClone
rs.Find "[ContractID]=" & lngContractID
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
I must site the Heisenberb Uncertainty Principal here, as it
works fine while I "observe the system" ... stepping through
the code using F8. But, when I let the code run on it''s own
the ADO recordset is at EOF.
So long as I create an artificial pause, by stepping through,
the recordset gets populated, but not when it runs at full speed.
The data is in SQL Server. Could the network retrieve time
be doing it? Is there a different way to navigate to a record
when in an ADP?
Danny J. Lesandrini
dl*********@hotmail.com
http://amazecreations.com/datafast
"Danny J. Lesandrini" <dl*********@hotmail.com> wrote in news:bt81vj
371s4
1
@ID-82595.news.uni-berlin.de:
The following code works with a standard MDB to navigate
to a particluar record (with a DAO recordset, of course)
but it''s giving me problems in an ADP I''m working on.
Dim rs As ADODB.Recordset
Set rs = Me.RecordsetClone
rs.Find "[ContractID]=" & lngContractID
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
I must site the Heisenberb Uncertainty Principal here, as it
works fine while I "observe the system" ... stepping through
the code using F8. But, when I let the code run on it''s own
the ADO recordset is at EOF.
So long as I create an artificial pause, by stepping through,
the recordset gets populated, but not when it runs at full speed.
The data is in SQL Server. Could the network retrieve time
be doing it? Is there a different way to navigate to a record
when in an ADP?
Danny J. Lesandrini
dl*********@hotmail.com
http://amazecreations.com/datafast
Usually we set the row position explicitly with a .MoveFirst before
"Finding" in ADO but I do not know if this has anything to do with what you
report here.
--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)
这篇关于使用rs.Bookmark导航到记录的ADP问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
