#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2004
    Location
    Cape Town, South Africa
    Posts
    51
    Rep Power
    11

    How to call UDF with params


    Hi All

    How do i call a UDF in FB?

    Thnks Wb
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Posts
    250
    Rep Power
    14
    In a stored procedure/trigger:

    myvariable = my_function(param1, paramn...);

    In a SELECT or other statement:

    SELECT mycolumn, my_function(anothercolumn, value)
    FROM ...
    etc


    With regards,

    Martijn Tonies
    Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server.
    Upscene Productions
    http://www.upscene.com
    Martijn Tonies
    Database Workbench: developer IDE for Firebird, MySQL, InterBase, MSSQL Server and Oracle
    Upscene Productions
    http://www.upscene.com
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2004
    Location
    Cape Town, South Africa
    Posts
    51
    Rep Power
    11

    Thumbs up


    Thanks!! - upscene, you need just one more post then you can have an avatar!!
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Posts
    250
    Rep Power
    14
    you need just one more post then you can have an avatar
    That, I did not know... Does this qualify as a post


    btw, my sig doesn't show automatically, any idea?
    Martijn Tonies
    Database Workbench: developer IDE for Firebird, MySQL, InterBase, MSSQL Server and Oracle
    Upscene Productions
    http://www.upscene.com
  8. #5
  9. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2004
    Location
    Cape Town, South Africa
    Posts
    51
    Rep Power
    11
    Originally Posted by upscene
    btw, my sig doesn't show automatically, any idea?
    No idea checkout the User CP Settings.

IMN logo majestic logo threadwatch logo seochat tools logo