Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Unanswered: Records affected

    How ca you determine the number of records affected in an Upadte Query?

    I turned the Warning Off, but I want to write this number to a in e.g. TextBox.

  2. #2
    Join Date
    Sep 2003
    Location
    T.O.
    Posts
    326
    In ADO it's a return parameter of ConnectionString.Connection.Execute "SQL", [RecordsAffected]

    RecordsAffected is of long datatype and you would place a long variable there to hold it.

    In DAO, I think your querydef object that executed holds the number
    qdf.Execute "SQL"
    lngAffected = qdf.RecordsAffected.

    HTH.
    All code ADO/ADOX unless otherwise specified.
    Mike.

  3. #3
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Thank you, for that nice info

Posting Permissions

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