silly question - do you have the udf ddl library installed?
Alan

> -----Original Message-----
> From: Charles Urbina [mailto:curbina@...]
> Sent: Sunday, 20 October 2002 9:04
> To: IBObjects@yahoogroups.com
> Subject: [IBO] UDF help
>
>
> I trying to duplicate a formula that I have used in an excell sheet. now I
> need to use it in a stored procedure but I get an error when I compile it.
>
> Error "invalid data type, length, or value Function SR_Trunc could not be
> matched" I also tried using F_TRUNCATE function and I get the same result.
>
> /* This is my Excell formulas */
>
> =IF(M2>9,TRUNC((M2-MOD(M2,10))/10)+MOD(M2,10),M2)
>
> /* In my Stored procedure*/
> this one gives the error.
>
> IF (:D4 > 9) then
> D4 = SR_TRUNC((:D4-MOD(:D4,10))/10 + MOD(:D4,10),:D4);
>
> /* In my Stored procedure*/
> when I use this line I don get an error but I don't get the correct result
> from the formula.
>
> IF (:D4 > 9) then
> D4 = SR_TRUNC(:D4-MOD(:D4,10))/10 + MOD(:D4,10);
>
> Can someone help me creating a formula with IB that will generate the same
> result as the one in excell.
>
> Tia
> Charles Urbina
>
>
>
>
>
>
> __________________________________________________________________
> _________
> IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> without the need for BDE, ODBC or any other layer.
> __________________________________________________________________
> _________
> http://www.ibobjects.com - your IBO community resource for Tech
> Info papers,
> keyword-searchable FAQ, community code contributions and more !
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>