Adding row to ADO reccrodset table

[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!

 

[Gerald Klein]

Are you talking about a datatable??

 

[MattB]

Yes, and I just figured it out, so nevermind. Thakns for the reply!