Re: ISO-11197 help

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Joe Celko (jcelko212_at_earthlink.net)
Date: 06/18/04 

Date: Thu, 17 Jun 2004 18:20:51 -0700

>> Ah, but what happens if you decide to change currencies in the
future? <<

You now have an easy to read pattern:

"<from ISO currency code><underscore><to ISO currency
code><underscore>ratio"

My validation comes from the three letter ISO currency codes. My and
verification comes from some banking website.

A change in currency would create a new data element in the model. If
uyou are in the EU these days, I suppose the right way would be to
convert everything to EUR and back out again.

--CELKO--
 ===========================
 Please post DDL, so that people do not have to guess what the keys,
constraints, Declarative Referential Integrity, datatypes, etc. in your
schema are.

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: Economic meltdowns in SF
    ... William December Starr: ... But that currency should have been very, ... should have noted that there was a pattern to "damage" on bills. ...
    (rec.arts.sf.written)
  • Re: Expr. Box
    ... Make the field (which will need to be a Single, Double, Currency or Decimal ... validation rule put ... John W. Vinson [MVP] ...
    (microsoft.public.access.tablesdbdesign)
  • Re: remove numbers from a string
    ... i believe you can replace numbers with this pattern: ... assuming you want to also remove associated markup that goes with certain ... currency, phone numbers, etc. ... Prev by Date: ...
    (alt.php)