• 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
• 2
• 3
• 4
• 5

(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: