Add a new record is way through the RecordSet object Addnew achieved, or by executing SQL statements in the insert statement can also add new records, why not choose the latter case? What is the difference between the two then?
In essence, ADO's Addnew method simply "Insert into" statement to package up, so direct use of SQL statement will greatly accelerate the speed of access to data, because he reduced the ADO's "translation" of time, especially when on When large amounts of data to operate more obvious. However, the shortcomings of the direct use of SQL statements: can not transfer the contents of the field too long, in the IMAGE field to the database by adding data, long text data, you need to use Addnew the. In addition, when the field is relatively long time to be a very long SQL statement, which led to easy troubleshooting, experienced programmers recommend priority.
In comparison, RecordSet object Addnew method first need to create a RecordSet object can be updated and maintained to Update the end, it is more consumption of system resources. But it has the advantage of better flexibility, code easy to read, easy debugging, recommend new users.
Recommand Link:
SuperAVConverter
Comment: Who than anyone else how Many rogue
"Do not call me"
Colorful Music Editor Lite Version
Flv to mp4 converter
SWF format
Youtube Video To Palm OS Live
Merry CDA WAV DVD-Audio to CD-R Copy
brief Genealogy
Evaluate Graphic Viewers
Font Tools Catalogs
Music COLLECTION
convert AAC to mp3
Youtube Movie To WMV Help
free converter mp4 to 3gp
No comments:
Post a Comment