Can anybody inform me about how to add a new Database field to a
already-existing paradox table
at runtime.

Note:
Delphi 5.0 Help say that I can't use "AddFieldDef" because it cannot be used
to add fields to an already-existing table.

Any help is highly appreciated.

Use the local SQL statement ALTER TABLE, executed from a TQuery.

  ALTER TABLE "Customer.db"
  DROP COLUMN FullName
    ADD COLUMN LastName CHAR(35)
    ADD FirstName CHAR(25)

Local SQL (the SQL implementation the BDE uses for dBASE, Paradox, and
FoxPro tables) is documented in the online help file LOCALSQL.HLP, found in
the main BDE directory. This help file is a language reference of the local
SQL implementation (subset) of SQL-92. The copy of this file that came with
BDE 4.x (and earlier versions) was seriously out of date and contained
little useful information. It has since been rewritten. It has been updated
again concurrent with C++Builder 5. Updated copies will have the topic
"VIEWs" in the index (and lack of this topic indicates a pre-update copy).
I can e-mail you a copy of the updated file if you need and desire it.

Another way is with the BDE API function DbiDoRestructure. BDE API
functions are documented in the BDE online help, BDE32.HLP, found in the
main BDE directory. To make a direct call to a BDE API function from a
Delphi unit, the BDE wrapper unit named "BDE" must be named in the unit's
Uses section.

I am trying to find the field type of a Money (Currency) field without
success - strings, dates, time, no problem...  anyone know it?

--
Pete Clark

        Oi...

        Create a blank new table with with the old fields + the new
field...

        batch move all records to the new table

        close both tables

        rename old table to *.bak
        rename new table to the name it should be (*.px)

        ZEE

On Thu, 17 Feb 2000 14:22:28 +0100, "Steffen Kristensen"