Strange problem with return values of UDF in proc

[Crowley16]

Hi everyone

I have a proc which selects data from some tables and a inline udf. The udf returns a varchar(500) and is just called from the select statement.

the proc works fine when run from query analyser however when I try to run it from ADO, it doesn't return any records. If the udf is removed from the proc, then records are returned.

anyone have any ideas why this is?

Thanks.

--------------------
Procrastinate Now!

 

[zhavic]

Can you post there your ADO statement ?

Zhavic

---------------------------------------------------------------
In the 1960s you needed the power of two Comodore64s to get a rocket to the moon. Now you need a machine which is a vast number of times more powerful just to run the most popular GUI.