Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How Recordset close in the vb6

Posted on 2006-11-20
1
Medium Priority
?
666 Views
Last Modified: 2008-01-09
Hi,
How i m know in the project which form has which recordset open. in visualbasic 6.0. i m using vb6 + msAccess
0
Comment
Question by:jay_gadhavi
1 Comment
 
LVL 5

Accepted Solution

by:
sivachirravuri earned 1500 total points
ID: 17977795
Hi,

Consider "rs" as record set.

rs.state will return you whether it is Open or close
For close it will return 0


'Sample code

Dim rs As New ADODB.Recordset

Private Sub Form_Load()
If rs.State = adStateclosed Then Msgbox "Connection closed"
End Sub
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Computer science students often experience many of the same frustrations when going through their engineering courses. This article presents seven tips I found useful when completing a bachelors and masters degree in computing which I believe may he…
This article will show how Aten was able to supply easy management and control for Artear's video walls and wide range display configurations of their newsroom.
Introduction to Processes
Loops Section Overview

972 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question