Change table structure

How Can I change table structure from my app? I need to insert new string field into my table from my app.

table structure  (Paradox table)

FIELDNAME   FIELDTYPE SIZE

name                A   30
adress              A   30
city                A   30


new table structure  (Paradox table)

FIELDNAME   FIELDTYPE SIZE
name                A   30
adress              A   30
city                A   30
state               A   30
VovbagerAsked:
Who is Participating?
 
kretzschmarConnect With a Mentor Commented:
well vov,

glad to hear :-)
then you can delete this q or
accept my comment as answer

meikl
0
 
kretzschmarCommented:
hi vovbager

use a query with a statement like this

alter table YourTableName add State CHAR(30)

and fire this statement with query1.ExecSQL

meikl
0
 
VovbagerAuthor Commented:
thank kretzsmar I alredy found it in Local SQL Help

Thanx VOV
0
 
VovbagerAuthor Commented:
thanx
0
All Courses

From novice to tech pro — start learning today.