using functions on ADP

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roy Goldhammer - 20 Sep 2007 12:13 GMT

Hello there

I have an ADP application run for some time at my work.

Suddnly i can't use table_based functions anymore. When I run them they
don't do anything

What can cause it? help

Reply to this Message

Sylvain Lafontaine - 20 Sep 2007 15:43 GMT

Well, you don't tell us how you are calling your table based UDF so it's
hard to tell you what might have gone wrong. Maybe a problem with the
schema (dbo., ...); as it's often the case with UDF? Are you working
against SQL-2000 or 2005? With what version of ADP? If it's with ADP 2003,
did this problem appear since the installation of Office Service Pack 3?

Signature

Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)

> Hello there
>
[quoted text clipped - 4 lines]
>
> What can cause it? help

Reply to this Message

Roy Goldhammer - 21 Sep 2007 13:44 GMT

Whell Sylvain

I'm using ADP 2003 and sql server 2005

All my functions have dbo owner

The problem occur even when I use Database window and Rress function to work

This problem didn't occur before and suddenly it started.

Even when I create new ADP and connect to the database this problem still
occur.

I even restore the database a week ago to point where it works and that even
didn't solve the problem

What can cause it? maybe it something i've installed on my computer?

> Well, you don't tell us how you are calling your table based UDF so it's
> hard to tell you what might have gone wrong. Maybe a problem with the
[quoted text clipped - 11 lines]
>>
>> What can cause it? help

Reply to this Message