Error occurs when you navigate a recordset relative to a deleted row after a Delete operation. After a row is deleted, its bookmark is removed from the rowset. The MoveNext and other methods use bookmarks to navigate the recordset.
Sample code that will produce the error
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
cn.Open "Provider=Scantron.Oledb;Location=c:\oledb\data\z701
rs.Open "select * from master", cn, adOpenDynamic, adLockOptimistic
Dim data1, data2 As String
data1 = "701000001001102700001 Y 5310 #0001 N ALL RIGHT M1003211947012345678998765412345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345 "
data2 = "701000002001102700001 Y 5310 #0001 N ALL RIGHT M1003211947012345678998765412345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345 "
rs.AddNew "raw", data1 & vbCrLf
rs.AddNew "raw", data2 & vbCrLf
rs.Delete adAffectCurrent
rs.MoveNext
Resolution
This defect is expected be resolved for the released product. In the interim, discard and reestablish any bookmarks. MoveFirst will work if your intention is to delete all records in a recordset.
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
cn.Open "Provider=Scantron.Oledb;Location=c:\oledb\data\z701
rs.Open "select * from master", cn, adOpenDynamic, adLockOptimistic
Dim data1, data2 As String
data1 = "701000001001102700001 Y 5310 #0001 N ALL RIGHT M1003211947012345678998765412345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345 "
data2 = "701000002001102700001 Y 5310 #0001 N ALL RIGHT M1003211947012345678998765412345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345 "
rs.AddNew "raw", data1 & vbCrLf
rs.AddNew "raw", data2 & vbCrLf
rs.Delete adAffectCurrent
rs.MoveFirst
Limitation Status
This defect is expected be resolved for the released product.
|
See Help on Help for additional information on using this help file. See Scantron Technical Support for additional information on technical support and training options. See the ScanTools Suite System Requirements for further details on hardware and software requirements. ScanTools is a suite of products; the specific information you want may appear in the help for a different module. If you don't find what you're looking for here, try one of the following:
|
Scantron Corporation
Customer Service (forms, products, and services): 1-800-SCANTRON (722-6876) Technical Support: 1-800-445-3141 |
|
|
Copyright © 1998-2012 Scantron Corporation. All rights reserved. Use permitted only under license. www.scantron.com. No part of the Help or user guides may be reproduced in any form, or by any means, without express permission from Scantron Corporation. LINKS TO THIRD PARTY SITES This help system may contain links to third party websites ("Linked Sites"). The Linked Sites are not under the control of Scantron and Scantron is not responsible for the content of any Linked Site, including without limitation any link contained in a Linked Site or any changes or modifications to a Linked Site. Scantron is not responsible for web casting or any other form of transmission received from any Linked Site. Scantron provides Users with the ability to link the Assessment System to the Linked Sites as a convenience to you, and the inclusion of any link does not imply endorsement by Scantron of the Linked Site or any association with its operators. |
||