Should I use currency or num(14,2) ? - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Should I use currency or num(14,2) ?

Message

De

06/10/1999 08:06:10

Janis Booth
Webmd
Prospect, Connecticut, États-Unis

À

05/10/1999 21:40:50

Eric Crespin
Pc Plus Inc.
Montréal, Québec, Canada

Information générale

Forum:

Visual FoxPro

Catégorie:

Base de données, Tables, Vues, Index et syntaxe SQL

Titre:

Re: Should I use currency or num(14,2) ?

Divers

Thread ID:

00273031

Message ID:

00273087

Vues:

20

>Does it make more sense to use the currency type or the numeric (14,2) ? It is for North America. Does it mater ?
>
>Thanks
>Eric.

In addition to what Steven told you, currency takes 8 bytes and your numeric will take 17 bytes in the dbf storage( over double the space).

Janis

www.JamesBooth.com

Click here to load this message in the networking platform