Creates a disconnected recordset at runtime

by Dennis Anthony (3 Submissions)
Category: Databases/Data Access/DAO/ADO
Compatability: VB 6.0
Difficulty: Unknown Difficulty
Originally Published: Thu 19^th June 2003
Date Added: Mon 8^th February 2021
Rating: (1 Votes)

API Declarations
'Don't forget to make an ADO reference

Rate Creates a disconnected recordset at runtime



    
rs.Fields.Append "au_id", adVarChar, 11
rs.Fields.Append "au_lname", adVarChar, 40
rs.Fields.Append "au_fname", adVarChar, 20
rs.Fields.Append "phone", adChar, 12
rs.Fields.Append "address", adVarChar, 40
rs.Fields.Append "city", adVarChar, 20
rs.Fields.Append "state", adChar, 2
rs.Fields.Append "zip", adChar, 5
rs.Fields.Append "contract", adBoolean

' Add a new record to it
rs.Open
rs.AddNew
rs("au_id") = "978-43-6543"
rs("au_fname") = "Francesco"
rs("au_lname") = "Balena"
rs("city") = "Menlo Park"
rs("State") = "CA"
rs("Zip") = "94025"
rs("Contract") = 1
rs.Update

Download this snippet Add to My Saved Code

Creates a disconnected recordset at runtime Comments

No comments have been posted about Creates a disconnected recordset at runtime. Why not be the first to post a comment about Creates a disconnected recordset at runtime.

Creates a disconnected recordset at runtime

Creates a disconnected recordset at runtime Comments

Post your comment

Difficulty