• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• Creates a disconnected recordset at runtime

Creates a disconnected recordset at runtime

Creates a disconnected recordset at runtime

API Declarations


'Don't forget to make an ADO reference



Rate Creates a disconnected recordset at runtime

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

    
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