• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• One line code for inserting a Single and Double Quote into the database using execute

One line code for inserting a Single and Double Quote into the database using execute

One line code for inserting a Single and Double Quote into the database using execute

API Declarations


' Activx Data Object 2.5 Library
DIM CN AS CONNECTION



Rate One line code for inserting a Single and Double Quote into the database using execute

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

cn.execute ("INSERT INTO ABC VALIES('" &replace(txtDescription,"'","''") & "'")
end sub