Subject Re: [IBO] Float to Numeric
Author Mark Pickersgill
Hi Don,

thought I'd throw my 2 cents worth in...
perhaps you could create an external file through Firebird
and write the "cast" values to it. If they come out as you wanted,
then you could re-select them from the external file.

Note, I haven't verified this, it's just a suggestion.


Thursday, January 8, 2004, 4:36:02 PM, you wrote:

DG> "Helen Borrie" <helebor@...> wrote in message
DG> news:<>...
>> At 10:07 PM 7/01/2004 -0600, you wrote:
>> Try this:
>> update classsubject
>> set weight = cast (cast (weight1 * 100 as numeric(7,2)) / 100 as
DG> numeric(5,2))

DG> Well, the cast doesn't work no matter what I do. I hate to have add a UDF
DG> just for this. Are you sure this isn't a bug in FB 1.5 RC6?

>> Helen

DG> _________________________________________
DG> Don Gollahon
DG> dlgllhn@...
DG> ICQ#: 115831669
DG> "What in Eternity does it matter?"
DG> _________________________________________

DG> ___________________________________________________________________________
DG> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
DG> without the need for BDE, ODBC or any other layer.
DG> ___________________________________________________________________________
DG> - your IBO community resource for Tech Info papers,
DG> keyword-searchable FAQ, community code contributions and more !

DG> Yahoo! Groups Links

DG> To visit your group on the web, go to:

DG> To unsubscribe from this group, send an email to:

DG> Your use of Yahoo! Groups is subject to: