DBASE - Numeric field format

Gus

Delphi Developer

Fri, 29 Jul 2005 23:02:22 GMT

DBASE - Numeric field format

Hello
How can I create NUMERIC size 16 scale 3, field format in DBASE (in
Delphi 6.0) ??
SQL : ' Create table a (NUMERIC (16,3))' >>> make (in SQLExpolrer)
Double (8) field type
Can someone help me?
Thanks, Gus

Richard Cart

Delphi Developer

Mon, 01 Aug 2005 09:53:04 GMT

Re:DBASE - Numeric field format

Quote

Gus (grz...@wp.pl) wrote:

: How can I create NUMERIC size 16 scale 3, field format in DBASE (in
: Delphi 6.0) ??
: SQL : ' Create table a (NUMERIC (16,3))' >>> make (in SQLExpolrer)
: Double (8) field type

Assuming you're using the BDE, see LocalSQL.hlp in your
BDE directory for the supported syntax.
--
Rick Carter
carte...@email.uc.edu Rick.Car...@ParadoxCommunity.com
Chair, Paradox/Delphi SIG, Cincinnati PC Users Group

Sundial Service

Delphi Developer

Wed, 03 Aug 2005 01:16:23 GMT

Re:DBASE - Numeric field format

Quote

Gus wrote:
> Hello
> How can I create NUMERIC size 16 scale 3, field format in DBASE (in
> Delphi 6.0) ??
> SQL : ' Create table a (NUMERIC (16,3))' >>> make (in SQLExpolrer)
> Double (8) field type
> Can someone help me?
> Thanks, Gus

In addition to the previous comments ... don't rely too much on the size and
scale of a numeric field, at least not with dBase or Paradox formats. (In
fact, not with /any/ database unless you know the representation is BCD =
Binary Coded Decimal.) The usual "float binary" representation of floating
point numbers is not as arithmetically accurate as SQL may imply. But "SQL
is only a /suggestion/ to the underlying database engine" on such points.

----------------------------------
Fast automatic Paradox/Delphi table repair at a click of a mouse!
http://www.sundialservices.com/products/chimneysweep

Other Threads

1. I need to know Lenght from a Numeric Field in DBASE format

2. Adding numeric field to dBase-table ????

3. Adding numeric fields to dBase-tables

4. length of dbase Numeric fields

5. DBASE Numeric Field width

6. dBase numeric field type issue

7. Numeric fields loose fieldtype in DBase

8. dbase: setting sizes of numeric fields in createtable?

9. Problems with dBase numeric fields

10. Dbase Tables and BatchMove Restructures Numeric Fields