Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

function erroring and reporting wrong name Expand / Collapse
Author
Message
Posted Wednesday, January 16, 2013 6:20 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, January 07, 2014 9:33 PM
Points: 4, Visits: 26
Hi All,

I have a weird one for you that I was hoping to get some help with.

I created and deleted a few functions.

Then I created a new one (Called RAT)

When I call it with SELECT dbo.rat(@param,@param) it comes back with a

"Cannot find either column "dbo" or the user-defined function or aggregate "dbo.RCHARINDEX", or the name is ambiguous."

Now, there used to be a function called RCHARINDEX, but its gone, and it doesnt come up in the list of functions.....

I deleted it because for some reason I couldnt call it, but another function in the list worked fine, so its possibly a compounded problem,

When I run

select 1 from dbo.sysobjects where id = object_id('[dbo].[RAT]')
select 1 from dbo.sysobjects where id = object_id('[dbo].[RCHARINDEX]')

I get a hit on the first one, but not on the second one.

I did drop the functions using the command:

Use Master
go
IF EXISTS (select 1 from dbo.sysobjects where id = object_id('[dbo].[RAT]') )
DROP FUNCTION [dbo].[RAT]

Any suggestions?

Regards
Post #1408115
Posted Wednesday, January 16, 2013 7:36 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, January 07, 2014 9:33 PM
Points: 4, Visits: 26
As a bit of additional info, intellisense picks up the function correctly.

But still getting:

select dbo.RAT(' ',' hey there dudes',1)
Msg 4121, Level 16, State 1, Line 1
Cannot find either column "dbo" or the user-defined function or aggregate "dbo.RCHARINDEX", or the name is ambiguous.
Post #1408123
Posted Wednesday, January 16, 2013 10:41 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 9:03 PM
Points: 1,128, Visits: 1,161
block 5753 (1/16/2013)
As a bit of additional info, intellisense picks up the function correctly.

But still getting:

select dbo.RAT(' ',' hey there dudes',1)
Msg 4121, Level 16, State 1, Line 1
Cannot find either column "dbo" or the user-defined function or aggregate "dbo.RCHARINDEX", or the name is ambiguous.

you are not calling function "dbo.RCHARINDEX" from the dbo.RAT function ??
can you post the text ?


~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one
Post #1408149
Posted Sunday, January 20, 2013 2:16 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, January 07, 2014 9:33 PM
Points: 4, Visits: 26
Hi There,

Yes I am very stupid.

That's what you get for using someone else's libraries :)

The RAT function called the RCHARINDEX inside it, and I missed the call when I was looking through the source.

So, I decided to re-write the function, and as I was doing do, I found the reference, and before I could log on you asked the question!

Thanks for you response.

Sorry to waste your time.

Regards
Post #1409307
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse