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

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

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

Message

From

06/10/1999 08:06:10

Janis Booth
Webmd
Prospect, Connecticut, United States

To

05/10/1999 21:40:50

Eric Crespin
Pc Plus Inc.
Montréal, Quebec, Canada

General information

Forum:

Visual FoxPro

Category:

Databases,Tables, Views, Indexing and SQL syntax

Title:

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

Miscellaneous

Thread ID:

00273031

Message ID:

00273087

Views:

21

>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