- Home
·
- Miscellaneous
·
- Returns Table Data! Returns Data over ADO from a given Field in a given Table with a given conditio
Returns Table Data! Returns Data over ADO from a given Field in a given Table with a given conditio
Returns Table Data! Returns Data over ADO from a given Field in a given Table with a given condition. Makes it easier to get the data of only
Rate Returns Table Data! Returns Data over ADO from a given Field in a given Table with a given conditio
(1(1 Vote))
'22.3.200 [email protected]
'cnnMain = Open Connection
On Error GoTo Err_ReturnTableData
Dim rstRec As New ADODB.Recordset
Dim strSQL As String
Let strSQL = "SELECT " & strReturnField & " FROM " & strTableName & " " & strWhereCondition
rstRec.Open strSQL, cnnMain, adOpenStatic, adLockOptimistic
If rstRec.RecordCount > 0 Then
ReturnTableData = NullChecked(rstRec(strReturnField))
Else
ReturnTableData = ""
End If
Exit_ReturnTableData:
Exit Function
Err_ReturnTableData:
'your error handling here
Resume Exit_ReturnTableData:
Returns Table Data! Returns Data over ADO from a given Field in a given Table with a given conditio Comments
No comments yet — be the first to post one!
Post a Comment