function erroring and reporting wrong name

• block 5753

  SSC Rookie

  Points: 26

  More actions

  January 16, 2013 at 6:20 pm

  #268730

  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

• block 5753

  SSC Rookie

  Points: 26

  More actions

  January 16, 2013 at 7:36 pm

  #1578068

  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.

• demonfox

  SSCertifiable

  Points: 6289

  More actions

  January 16, 2013 at 10:41 pm

  #1578085

  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 :ermm:

• block 5753

  SSC Rookie

  Points: 26

  More actions

  January 20, 2013 at 2:16 pm

  #1579046

  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