Executing a function

[mepancha]

Hi,
I have created a function test under the user name tom.dick under the database TELEVISION.

I executed the following sql in the query analyzer
SELECT TOP 1 CLIENT_NO, ACCOUNT,
tom.dick.test(CLIENT_NO),
tom.dick.test(CLIENT_NO)
FROM test_table
ORDER BY CLIENT_NO

I get the following error
Invalid object name 'tom.dick.test'.

I change the SQL to the following
SELECT TOP 1 CLIENT_NO, ACCOUNT,
TELEVISION.tom.dick.test(CLIENT_NO),
TELEVISION.tom.dick.test(CLIENT_NO)
FROM test_table
ORDER BY CLIENT_NO

I get the following error
The object name 'TELEVISION.tom.dick.' contains more than the maximum number of prefixes. The maximum is 2.

Please let me know as to how I solve this problem.

Thanks in advance

 

[JayKusch]

Maybe ...

SELECT TOP 1 CLIENT_NO, ACCOUNT, 
    test(CLIENT_NO),
    test(CLIENT_NO)
FROM test_table
ORDER BY CLIENT_NO

Thanks

J. Kusch