Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Community Discussions (All other subjects)
 Insert vs AddNew
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

GauravBhabu
Advanced Member

4288 Posts

Posted - 12 February 2003 :  07:57:39  Show Profile
When adding a new record, is there any advantages/disadvantages using

AddNew vs INSERT

Nikkol
Forum Moderator

USA
6907 Posts

Posted - 12 February 2003 :  08:02:13  Show Profile
Found these:
http://dbforums.com/arch/66/2002/5/389655
http://www.stardeveloper.com/articles/display.html?article=2000032601&page=1

Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~
Go to Top of Page

Doug G
Support Moderator

USA
6493 Posts

Posted - 12 February 2003 :  11:02:51  Show Profile
Well, you can do an insert without instantiating a recordset object.

If you need to access the recordset data after the insert, it would be better to use addnew. If not, performance will probably be a bit better if you do an insert sql statement directly on the connection.

$0.02

======
Doug G
======
Computer history and help at www.dougscode.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.28 seconds. Powered By: Snitz Forums 2000 Version 3.4.07