
D▄Lï(
o│µ"2}	d/àτ┤

Database Field Name
────────────────────────────────────────────────────────────

This is the name of the current field.  This can be up to
ten characters in length.  It can be made of letters, digits,
and underscores (_), but the first character must be a letter.

Example:
                TEST            Correct
                _TEST           Incorrect
                TEST_123        Correct
                123_TEST        Incorrect

See Also:
 ~50~Modifying a database's structure~
 ~100~Ordering Information~


Database Field Type
────────────────────────────────────────────────────────────

This is the current field's type.  There are five options;

  Character     Any type of information including binary
  Number        Numbers only
  Date          Dates only
  Logical       True of False
  Memo          Any type of information, but can range upto 64k

See Also:
 ~12~Field Length~
 ~13~Field Decimal Places~
 ~50~Modifying a database's structure~
 ~100~Ordering Information~


Database Field Length
────────────────────────────────────────────────────────────

The length of the current field.

  Type        Length
  ────        ──────
  Character   1 to 65533, 1 to 254 for dBASE compatibility
  Number      1 to 19 including decimal place
  Date        8
  Logical     1
  Memo        10

See Also:
 ~50~Modifying a database's structure~
 ~100~Ordering Information~


Database Field Decimal Places
────────────────────────────────────────────────────────────

The number of decimals for the current field.

This field is only valid for Numeric types.  All other types
should have a zero (0) in this field.

The maximum value for this field is length -2.

See Also:
 ~50~Modifying a database's structure~
 ~100~Orderinf Information~


File Type
────────────────────────────────────────────────────────────

The type of database saved.  This value only realy matters
when you include memo fields in your database.

Some other restrictions also come into play:

Maximum Record length:
   4000 bytes
   8192 bytes (Clipper 5.0)

Maximum Number of Fields:
    128 dBASE III+
    255 dBASE IV, FoxPro
    512 dBXL
   1023 Clipper 5.0

Maximum Length of Numeric Fields:
     19 dBASE III+, FoxBASE
     20 dBASE IV , FoxPro


Modifying a database's structure
────────────────────────────────────────────────────────────

When you modify an existing database's structure, dB Online's
Assist will copy over the records from the original database
to the new structure.

If you there are some fields from the original database that
are not including in the new datebase, the information will be
lost.

If the original database includes fields with the same name
as in the newer database but different types, the data is
correctly copied into the newer database only if the newer
field is either of character or numeric type.

See Also:
 ~100~Ordering Information~


Ordering Information
────────────────────────────────────────────────────────────

Pricing:

  dB Online         95.00 US$
  dB Online Pro    195.00 US$
    - allows for use without a BBS


Addesses:

          {Sound Advice Limited}
          P.O. Box 10560, Gladstone, MO 64188-0560 U.S.A.

Sales:    1-800-847-4763
          1-816-436-5206
Support:  1-816-436-5409
Fax:      1-816-436-5509
BBS:      1-816-436-4516

Internet: info@sound.com
          sales@sound.com
          merlin.support@sound.com
FidoNet:  1:280/1
MHS:      info @ merlin [cserve]

d