Board index » delphi » Add field to a table programatically?(Alter table)

ooo

Delphi Developer
Mon, 22 Jan 2001 03:00:00 GMT

Add field to a table programatically?(Alter table)

I need to add field to a table programmatically. The database is
dbase..anyone has any pointers?
 
Brian Bushay Tea

Delphi Developer
Wed, 24 Jan 2001 03:00:00 GMT

Re:Add field to a table programatically?(Alter table)


Quote
>I need to add field to a table programmatically. The database is
>dbase..anyone has any pointers?

the easiest way to do this is with SQL

ALTER TABLE "customer.dbf"
ADD "customer.dbf"."#ID" CHAR(3)

--
Brian Bushay (TeamB)
Bbus...@DataGuidance.com

Other Threads

1. How to: programatically adding a field to a table

2. Alter Table add autoinc field

3. How to update fields of a table without commit between every ALTER TABLE

4. CREATE TABLE vs CREATE TABLE + ALTER TABLE

5. How to: programatically adding INDEX to MS ACCESS table

6. ALTER TABLE: adding DEFAULT and NOT NULL

7. ALTER TABLE/ALTER COLUMN problem with MS Access 2K

8. IB6.0 Bug? ALTER TABLE ALTER Fieldname

9. Lock Access table prior to ALTER TABLE

10. altering the table language of an existing table