Results 1 to 2 of 2

Thread: EOF Issue

  1. #1
    Join Date
    Apr 2003

    Unanswered: EOF Issue

    I am trying to write data to a recordset and it doesn't write to the last record. Here is my code:

    Set rs = New ADODB.Recordset
    rs.Open sql, conn, 1, 2
    With rs
    j = 0
    Do While Not rs.EOF
    rs(0).Value = j
    j = j + 1
    End With
    Set rs = Nothing

    I think the problem is my eof setting but I don't know how to adjust that in code since I am not using an adodc. If that is my problem then can I get the code snippet, please?

    Otherwise, what is my problem?


  2. #2
    Join Date
    Aug 2002
    Have you referred to any VB forums, as I can see most of the SQL database related questions. Try it and see.
    --Satya SKJ
    Microsoft SQL Server MVP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts