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.
Recommended links:
Infomation Games Board
SAN TERMINOLOGY Reference Table
Articles about Help Tools
Chi-line LUBRICATION experts
Ministry of Information Industry said the first year RFID frequency schedule announced
mp4 to avi
Screen Savers Specialist
CONVERT flv to wmv
"The Sims 3" fun things continue to occur
The latest satellite positioning chips used indoors less than one second positioning
Principal to ensure each experience a 20 006 practice site
Music TV infringement trial basis have a SPECIAL levy to the views of the community
mov Video
Photoshop font effects - Ice text
Art - Screen Savers Report
Matroska video file
No comments:
Post a Comment