Subject | Re: [IBO] UDF help |
---|---|

Author | Charles Urbina |

Post date | 2002-10-20T16:31:17Z |

Alan,

when I tried clonning the excell formula exactly as I have it in excell.

/* This is my Excell formulas */

=IF(M2>9,TRUNC((M2-MOD(M2,10))/10)+MOD(M2,10),M2)

/** my SP *//

IF (:D4 > 9) then

D4 = SR_TRUNC((:D4-MOD(:D4,10))/10 + MOD(:D4,10),:D4); <<-- here I get the

error.

But if I do this I don't get the error but. the formula is not complete.

IF (:D4 > 9) then

D4 = SR_TRUNC(:D4-MOD(:D4,10))/10 + MOD(:D4,10); <<- Here I'm missing the

las part of the excell fomula

Charles

> silly question - do you have the udf ddl library installed?yes I do I have compiled this stored procedure already. I get the error only

> Alan

when I tried clonning the excell formula exactly as I have it in excell.

/* This is my Excell formulas */

=IF(M2>9,TRUNC((M2-MOD(M2,10))/10)+MOD(M2,10),M2)

/** my SP *//

IF (:D4 > 9) then

D4 = SR_TRUNC((:D4-MOD(:D4,10))/10 + MOD(:D4,10),:D4); <<-- here I get the

error.

But if I do this I don't get the error but. the formula is not complete.

IF (:D4 > 9) then

D4 = SR_TRUNC(:D4-MOD(:D4,10))/10 + MOD(:D4,10); <<- Here I'm missing the

las part of the excell fomula

Charles

>I

> > -----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

> > need to use it in a stored procedure but I get an error when I compileit.

> >be

> > Error "invalid data type, length, or value Function SR_Trunc could not

> > matched" I also tried using F_TRUNCATE function and I get the sameresult.

> >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

> > from the formula.same

> >

> > 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

> > result as the one in excell.http://docs.yahoo.com/info/terms/

> >

> > 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

> >___________________________________________________________________________

> >

>

>

>

>

>

> IB Objects - direct, complete, custom connectivity to Firebird orInterBase

> without the need for BDE, ODBC or any other layer.___________________________________________________________________________

>

> http://www.ibobjects.com - your IBO community resource for Tech Infopapers,

> keyword-searchable FAQ, community code contributions and more !

>

> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

>

>