is recordset open?

microsoft.public.sqlserver.programming

9 Dec 2005 11:37 PM

Les Stockton

Someone told me how to do this before, but I can't seem to find it.
I've got an ADO recordset. What attribute do I check to see if the
recordset is open or not?

9 Dec 2005 11:50 PM

Aaron Bertrand [SQL Server MVP]

Not sure what this has to do with SQL Server specifically, this will
probably vary depending on where you are using ADO. You're probably looking
for rs.state (e.g. adStateOpen). Open up your adovbs.inc file and look fo
adStateOpen to get the numeric constant.

A

Show quote

"Les Stockton" <LesStock***@discussions.microsoft.com> wrote in message
news:8FC89DE0-7E7A-4B85-AB0A-9302F224002E@microsoft.com...
> Someone told me how to do this before, but I can't seem to find it.
> I've got an ADO recordset. What attribute do I check to see if the
> recordset is open or not?
>