Subject | Re: [firebird-support] Func abs() in FB |
---|---|
Author | Helen Borrie |
Post date | 2008-04-11T09:14:31Z |
At 06:47 PM 11/04/2008, you wrote:
./heLen
>Dear All,the same - but in Fb 1.5 it is an external function (UDF) so you must declare it in the database in order to use it. You will find the declaration script in the /udf/ directory, in ib_udf.sql.
>
>Usually in mysql i use the syntax :
>UPDATE xtable
>SET qty=ABS(qty)
>WHERE qty<0;
>
>What I should type that command in FB 1.5?
./heLen