Cursor in UDF in ADP

[Patna]

Hi there,

I am using a user defined function with an T-SQL-Cursor in a view in m
adp.
the function returns a bit and calling the same view within my adp th
function returns 0 for the field, in Query analyzer it returns 1. Th
data has not changed in between.

Any ideas

Thanks

Patn

 

[Vadim Rapp]

P> I am using a user defined function with an T-SQL-Cursor in a view in
P> myadp. the function returns a bit and calling the same view within my
P> adp thefunction returns 0 for the field, in Query analyzer it returns 1.
P> Thedata has not changed in between.

hard to say without knowing the function. For example, the function may be
like this:

if app_name()='query analyzer' then return 1 else return 0


Vadim Rapp