Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2002
    Location
    Island of Dots
    Posts
    316

    Unanswered: Calling a single UDF multiple times within 1 View

    Lets say I have a User Defined Function. I need to call the UDF a number of times within the same View. However, the results are not as expected. The only way (I know of) is to have seperate instances on the same function saved under different names. Is there a way to call a single UDF multiple times within a View without the returned values being messed-up?

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    read the sticky at the top of the forum, and why not post what you have.
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Jul 2002
    Location
    Island of Dots
    Posts
    316
    Sorry about the ambiguity, missed the new sticky.

    I had this problem a few weeks ago, and ended-up having to create multiple instances of the UDF. However, I am now having problems recreating the error and was hoping that someone would have come accross what I described.

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Calling a function multiple times within a view will not screw anything up. There is something else fishy going on. Follow Brett's posting advice.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •