These are queries that are Add a New Record, Update and Existing Record and to Delete a Specific re

by Syed Zulfiqar Ali Hussain (1 Submission)
Category: Databases/Data Access/DAO/ADO
Compatability: VB 6.0
Difficulty: Unknown Difficulty
Originally Published: Thu 7^th March 2002
Date Added: Mon 8^th February 2021
Rating: (1 Votes)

These are queries that are Add a New Record, Update and Existing Record and to Delete a Specific record

Rate These are queries that are Add a New Record, Update and Existing Record and to Delete a Specific re



Set Rs = Db.Execute("Insert into Company (Cname,Loc) values ('" & Text1 & "','"& Text2 &"')")

'To Delete a Specific Record
Set Rs=Db.Execute("Delete from Company where Cname='"& Text1 &"'")

'To Update a Record
Set Rs = Conn.Execute("Update Company set  Cname='" & TxtCode & "',Loc='" & TxtName & "' where Cname = '" & Text1 & "'")

Download this snippet Add to My Saved Code

These are queries that are Add a New Record, Update and Existing Record and to Delete a Specific re Comments

No comments have been posted about These are queries that are Add a New Record, Update and Existing Record and to Delete a Specific re. Why not be the first to post a comment about These are queries that are Add a New Record, Update and Existing Record and to Delete a Specific re.

These are queries that are Add a New Record, Update and Existing Record and to Delete a Specific re

These are queries that are Add a New Record, Update and Existing Record and to Delete a Specific re Comments

Post your comment

Difficulty