Calling a UDF using ADO 2

[gradley]

Has anyone tried calling a SQL Server 2000 User Defined Function (UDF) using the ADO object model? I would like to execute this function from within a VB6 application passing a couple of parameters and returning a char(1) value.

I have tried researching this through MSDN but had no success. I would hate to have to create a Stored Procedure to mimic this logic.

Any help would be appreciated.

 

[Juice05]

You could create a stored procedure to simply call the UDF. You wouldn't have to duplicate the logic, just to refernce it.

 

[JamesLean]

I don't know whether you can call the function directly from the VB. But the easiest way I see is to execute a normal SQL query using the function and get the value back from the recordset:

Set oRS = oConn.Execute("SELECT dbo.my_func(" & intA & ", " & intB & ") AS the_answer")

strAnswer = oRS("the_answer")

--James

 

[gradley]

Both very good suggestions...

Thanks for the feedback.