asp_databases thread: recordset status
Message #1 by "Chris Yangouyian" <Chris@m...> on Fri, 27 Apr 2001 15:20:42 -0400
|
|
Hi there!
Is there a way for me to check the status of a recordset? I want to see if it is opened or closed. I have several different
recordsets in my code and it is hard to keep up with them all.
Any help would be greatly appereciated!
--
Regards,
Chris
--
Message #2 by "Fidel Leon Martin" <ea3gip@e...> on Sat, 28 Apr 2001 11:10:41 +0200
|
|
*********** REPLY SEPARATOR ***********
On 27/04/2001 at 15:20 Chris Yangouyian wrote:
>Is there a way for me to check the status of a recordset? I want to see
>if it is opened or closed. I have several different recordsets in my code
>and it is hard to keep up with them all.
Dim rsTable as ADODB.Recordset
Set rsTable=3DCreateObject("adodb.recordset")
.
.
rsTable.Open .....
.
.
.
if rsTable.State =3D adStateOpen then
Fidel Leon - EA3GIP
E-Mail: ea3gip@e...
http://www.ea3gip.net
PGP Public Key: http://www.ea3gip.net/ea3gip.asc
Message #3 by "Ken Schaefer" <ken@a...> on Sun, 29 Apr 2001 14:35:43 +1000
|
|
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: Is there a way for me to check the status of a recordset?
: I want to see if it is opened or closed. I have several different
: recordsets in my code and it is hard to keep up with them all.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
If objRS.State = adStateOpen then
' objRS is Open
Else
' objRS is Closed
End if
Cheers
Ken
|
View Cart
