Re: Recordset problem..

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

"Daniel" <Daniel@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6F8D60BE-6A8E-4ED2-A355-099AFCD562FE@xxxxxxxxxxxxx
> Hi..I have problem in reading the first record after looping the
> recordset once. Therefore, i cannot read any record in recordset
> after the first round reading.
> How to solve it? Any ideas?

What problem? what have you tried? How are you opening the recordset?

Assuming you haven't opened it with a forward-only cursor you should be able
to do a .MoveFirst to get back to the first record. If the recordset is
dynamic and/or the first entry has been updated or deleted there may be
other issues to handle. Without knowing what you are doing and what you are
trying to accomplish it's hard to give a meaningful answer.

--
Reply to the group so all can participate
VB.Net: "Fool me once..."

.

Relevant Pages

  • Re: GUI for access 2002
    ... just referencing the first record in it. ... Is it a one-record recordset, ... the form named "change members" is not opened, ... I spent some time tiring ...
    (microsoft.public.access.gettingstarted)
  • Re: SYNC Form to listbox
    ... Modified code: ... I am thinking of an alternative approach, that being a cloned recordset ... based on the option box criteria and then displaying the first record. ...
    (comp.databases.ms-access)
  • Re: Missing first row in recordset from excel using .getrows
    ... I'm using the following code to get a recordset of an excel file. ... the getrows call to fill the variant array p. ... I notice that in the first record, ... Dim RDB As ADODB.Record ...
    (microsoft.public.vb.database.ado)
  • Re: really baffled - a might OT about recordset EOF
    ... I've never seen a populated recordset return a true EOF ... > the first record if the recordset contains any recorcords at all, ... > quicker response by posting to the newsgroup. ...
    (microsoft.public.inetserver.asp.db)
  • Re: Fastest db methods?
    ... side-effects, such as scalability issues (for example, a SqlDataReader is ... > Reading a recordset using SqlDataAdapter.Fill/ reading a ... recordset using SqlDataReader ?? ... and then send the actual resultset. ...
    (microsoft.public.dotnet.framework.adonet)