Adding row to ADO reccrodset table

  • Thread starter Thread starter MattB
  • Start date Start date
M

MattB

I have an ADO recordset that is not associated with any particular database.
I want to add a row. Sounds simple but I'm not sure how to do it. Examples
I've found use an insert statement, but they are all connected to a SQL
database. I'm familiar with SQL and VFP but this is uncharted territory to
me. Can I still use a SQL insert? Should I do it using all object
references?

So I want to do the equivalent of this:

insert into myDataTable values(1, 'mystring1', 'mystring2', '2.5')

Thanks!
 
Back
Top