Jump to content

Recommended Posts

Posted

They must have a bigger problem with decimal database fields than they ever had with Y2K.

 

 

 

 

with modern relational databases we dont have much issue with storing large numbers. However, we run out of real estate on the paper when printing, so we've built a "divisor" into the system. I think currently they hide 9 zeros on all their reports

Posted

 

They must have a bigger problem with decimal database fields than they ever had with Y2K.

 

 

 

 

with modern relational databases we dont have much issue with storing large numbers. However' date=' we run out of real estate on the paper when printing, so we've built a "divisor" into the system. I think currently they hide 9 zeros on all their reports[/quote']

 

It should'nt be a problem if you define it as a floating point number but many databases have a decimal data type which handles rounding better than floating point does and there you do define the size of the decimal eg decimal(10, 2).

 

 

Posted

One speech that Bob gave a week or so ago, he said he refuses that Zimbabwe falls back into the hands of the British and their puppets, and that they reverse the progress and growth that his government brought.

 

WTF.

 

The only growth he has brought is the number of zeros behind all currency values.

 

 

Posted

hmmm firebird is cooler than expected. Database fields are defined as numeric(8,6), but i have values of "169500000000" in there no problem. Interesting... I will definitely keep an eye on it

Posted

One of my employees came back from Zim the other day and gave me a ZIM$25 billion note - about R10 or something.

They gonna have to start printing invoices in landscape, portrait won't fit all those zeros. Next will be A3 invoices and chequesLOL
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);

 

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