Closing Recordsets

Hi I just want to ask why I receive an error from

VB Code:

rs.open "Insert Into Table (a,b,c) values ('a','b','c')",con
rs.close:set rs=nothing

but not from

VB Code:

rs.open "Select * from table",con
rs.addnew
rs.update
rs.close:set rs=nothing

The error is "Function is not allowed when object is closed" ..... thanks in advance :)

the error happens in the rs.close code right

it is because the record is not actually opened. there is no such query as select into statement

maybe what you want is to insert a record to a database.

you should use insert into statement if thats the case

In the first example, the recordset wasn't ever opened.... no data was returned.

FYI: That's not a good way to run those kind of SQL Statements (the kind that don't actualy return data are called Action Queries - Insert, Delete, Update) but instead you should use the Command object and the Execute method. There's a couple of ADO tutorials in my sig, they go over this kind of stuff.

-tg

d3gerald: I mistyped :)
techgnome: thank you for the information. I will read the tutorials immediately. I did not realize that I was doing it the wrong way :thumb:

**Edit

Some of the links in your sig is broken :)

?? Really? Which one(s) .... I just checked them and they worked for me....

-tg