|
»
»
[Firebird-test] UDFs in procedure
|
View:
New views
4 Messages
—
Rating Filter:
Alert me
|
 |
[Firebird-test] UDFs in procedure
by napnap
::
Rate this Message:
Hello,
how to call UDFs function in procedure ? For example, I would like to create an alias of the UDF ASCII_CHAR : CREATE FUNCTION CHR(num NUMBER) RETURN CHAR IS chrRet CHAR(1); BEGIN RETURN(ASCII_CHAR(num)); END; This doesn't work....and I don't know why Thanks. ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Firebird-test mailing list Firebird-test@... https://lists.sourceforge.net/lists/listinfo/firebird-test |
|||
|
|
[Firebird-test] НА: UDFs in procedure
by Valentin Kazimirov
::
Rate this Message:
Hello UDF ONLY external :( declare external function invl int by descriptor, int by descriptor returns int by descriptor entry_point 'idNvl' module_name 'fbudf'; Create only Procedure i am too have create function in sql, but..... life is life
Hello, how to call UDFs function in procedure ? For example, I would like to create an alias of the UDF ASCII_CHAR : CREATE FUNCTION CHR(num NUMBER) RETURN CHAR IS chrRet CHAR(1); BEGIN RETURN(ASCII_CHAR(num)); END; This doesn't work....and I don't know why Thanks. ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Firebird-test mailing list Firebird-test@... https://lists.sourceforge.net/lists/listinfo/firebird-test ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Firebird-test mailing list Firebird-test@... https://lists.sourceforge.net/lists/listinfo/firebird-test |
|||
|
|
Re: [Firebird-test] UDFs in procedure
by Martijn Tonies
::
Rate this Message:
> how to call UDFs function in procedure ?
> > For example, I would like to create an alias of the UDF ASCII_CHAR : > > > CREATE FUNCTION CHR(num NUMBER) > RETURN CHAR > IS chrRet CHAR(1); > BEGIN > RETURN(ASCII_CHAR(num)); > END; > > This doesn't work....and I don't know why CREATE FUNCTION won't work cause Firebird is the only DBMS that doesn't support Stored Functions ;-) Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle & MS SQL Server Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Firebird-test mailing list Firebird-test@... https://lists.sourceforge.net/lists/listinfo/firebird-test |
|||
|
|
Re: [Firebird-test] UDFs in procedure
by Helen Borrie
::
Rate this Message:
At 01:35 AM 11/11/2006, you wrote:
>Hello, >how to call UDFs function in procedure ? > >For example, I would like to create an alias of the UDF ASCII_CHAR : > > >CREATE FUNCTION CHR(num NUMBER) > RETURN CHAR > IS chrRet CHAR(1); >BEGIN > RETURN(ASCII_CHAR(num)); >END; > >This doesn't work....and I don't know why Where on earth did you dig up this syntax? It's not part of Firebird's SQL language. If you want tech support, please don't use this list for it. This is strictly for reporting field test problems and results. Subscribe to the firebird-support list at http://www.yahoogroups.com/community/firebird-support. fwiw, you don't "alias" external functions by recreating them. You can use whatever name you like for a UDF when you declare it to your database, e.g. DECLARE EXTERNAL FUNCTION CHR INTEGER RETURNS CSTRING(1) FREE_IT ENTRY_POINT 'IB_UDF_ascii_char' MODULE_NAME 'ib_udf'; Helen (list admin) ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Firebird-test mailing list Firebird-test@... https://lists.sourceforge.net/lists/listinfo/firebird-test |
| Free Forum Powered by Nabble | Forum Help |
