Results 1 to 13 of 13

Thread: INSERT versus ADDNEW [RESOLVED]

Threaded View

  1. Aug 26th, 2005, 01:30 PM #1
    Pasvorto
    Pasvorto is offline

    Thread Starter
    PowerPoster Pasvorto's Avatar
    Join Date
    Oct 2002
    Location
    Minnesota, USA
    Posts
    2,951

    INSERT versus ADDNEW [RESOLVED]

    Which do you find the most efficient? Does it make a difference?

    INSERT INTO tablename ([fieldnames]) values (...)"

    or

    Set rs as adodb.record
    rs.open...
    rs.addnew
    ...
    ...
    ..
    rs.update
    rs.close
    set rs = nothing
    Last edited by Pasvorto; Aug 26th, 2005 at 03:03 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width