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

by Murali (2 Submissions)
Category: Databases/Data Access/DAO/ADO
Compatability: Visual Basic 5.0
Difficulty: Unknown Difficulty
Originally Published: Mon 18^th February 2002
Date Added: Mon 8^th February 2021
Rating: (1 Votes)

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



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

Download this snippet Add to My Saved Code

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

No comments have been posted about One line code for inserting a Single and Double Quote into the database using execute. Why not be the first to post a comment about 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 Comments

Post your comment

Difficulty