How to call a user defined function from VB

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Peri (lperi_at_CSPL.com)
Date: 05/25/04

  • Next message: ChrisM: "Looking for a Doc-To-Help Expert." 
    Date: Tue, 25 May 2004 14:11:55 +0530

    Hi,

    Can any one tell me how to call a user defined funtion from VB ?

    This is a partial Code.

    svValueString = "ABC"
    lngField = 1
    svValue = ""

    svSql = "SELECT dbo.fn_GetValue(svValueString, lngField)"

    Set rsTemp = New ADODB.Recordset

    With rsTemp
       .ActiveConnection = conn
       .CursorLocation = adUseClient
       .LockType = adLockOptimistic
       .Open svSql
    End With

    Debug.Print svValue

    Please let me know if this is right ?

    FYI - I am able to execute the function from SQL server query analyser. 

    -- 
Thanks and Regards,
Peri
  • Next message: ChrisM: "Looking for a Doc-To-Help Expert."

    Relevant Pages