Advertisement
Advertisement
| 03.31.2004 at 06:59AM PST, ID: 20938710 |
|
[x]
Attachment Details
|
||
|
[x]
The Solution Rating System
|
||
|
With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.
Your Input Matters If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support. Thank you! |
||
| Microsoft |
| Apple |
| Internet |
| Gamers |
| Digital Living |
| Virus & Spyware |
| Hardware |
| Software |
| ITPro |
| Developer |
| Storage |
| OS |
| Database |
| Security |
| Programming |
| Web Development |
| Networking |
| Other |
| Community Support |
| 03.31.2004 at 09:16PM PST, ID: 10729685 |
| 03.31.2004 at 11:07PM PST, ID: 10730039 |
| 04.01.2004 at 12:49AM PST, ID: 10730459 |
| 04.06.2004 at 06:27AM PDT, ID: 10765644 |
| 04.06.2004 at 07:59AM PDT, ID: 10766556 |
| 06.09.2004 at 09:17AM PDT, ID: 11271560 |
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: 37: 38: 39: 40: 41: 42: 43: 44: 45: 46: 47: 48: 49: 50: 51: 52: 53: 54: 55: 56: 57: 58: 59: 60: 61: 62: 63: 64: 65: 66: 67: 68: 69: 70: 71: 72: |
Option Explicit
Dim WithEvents Conn As ADODB.Connection
Dim WithEvents RS As ADODB.Recordset
Dim Counter As Long
Const DBConnection = "Driver={Microsoft ODBC for Oracle};Server=cruz1;UID=augustine;PWD=augustine;"
Private Sub Command1_Click()
Dim iCount As Long
iCount = 0
If mAcctId = 0 Then
mAcctId = 100000000
End If
Do While iCount < 10
mAcctId = mAcctId + 1
ExecuteQuery DBConnection, mAcctId
iCount = iCount + 1
Loop
End Sub
Private Sub Form_Load()
mAcctId = 0
Counter = 0
End Sub
Private Sub ExecuteQuery(ByVal DBConnString As String, AcctId As Long)
Dim SQL As String
SQL = "Select orderid from order where orderactid=999910605"
If DBConnString <> "" Then
Counter = Counter + 1
Set RS = New ADODB.Recordset
With RS
.CursorLocation = adUseClient
.Properties("Initial Fetch Size") = 0
.Properties("Background Fetch Size") = 1
'RS.ActiveConnection = GetConnection(DBConnString)
RS.Open SQL, GetConnection(DBConnString), , , adAsyncFetch
End With
End If
End Sub
Private Function GetConnection(DBConnString As String) As ADODB.Connection
'If Conn Is Nothing Then
Set Conn = New ADODB.Connection
Conn.Open DBConnString
'End If
Set GetConnection = Conn
End Function
Private Sub RS_FetchComplete(ByVal pError As ADODB.Error, adStatus As ADODB.EventStatusEnum, _
ByVal pRecordset As ADODB.Recordset)
Dim myConn As ADODB.Connection
Counter = Counter - 1
Set myConn = pRecordset.ActiveConnection
If Not myConn Is Nothing Then
myConn.Close
Set myConn = Nothing
End If
If Not pRecordset Is Nothing Then
If pRecordset.State <> adStateClosed Then
pRecordset.Close
End If
End If
End Sub
|