Jump to content

Recommended Posts

Posted

 

hmmm firebird is cooler than expected. Database fields are defined as numeric(8' date='6), but i have values of "169500000000" in there no problem. Interesting... I will definitely keep an eye on it[/quote']Fand, something like this?FormatFloat('#,000,000,000,000,000,000.00', FieldByName('Cost').AsCurrency);

 

 

 

I'm glad you dont work for me... smiley17.gif

 

 

 

its FormatFloat(SellFormat, FieldByName('Cost').AsCurrency);

 

 

 

sellformat is a string which is defined at startup and built up from regional settings

 

 

 

all those 0's and comma's are gonna confuse it   

Posted

 

 

hmmm firebird is cooler than expected. Database fields are defined as numeric(8' date='6), but i have values of "169500000000" in there no problem. Interesting... I will definitely keep an eye on it[/quote']Fand, something like this?FormatFloat('#,000,000,000,000,000,000.00', FieldByName('Cost').AsCurrency);

 

 

 

I'm glad you dont work for me... smiley17.gif

 

 

 

its FormatFloat(SellFormat, FieldByName('Cost').AsCurrency);

 

 

 

sellformat is a string which is defined at startup and built up from regional settings

 

 

 

all those 0's and comma's are gonna confuse it   

 

Oi, that's the quick fix!!!!  But that's what you need to display this NICELY EmbarrassedWink

 

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Settings My Forum Content My Followed Content Forum Settings Ad Messages My Ads My Favourites My Saved Alerts My Pay Deals Help Logout