Hi,

From within a program I need to
1) Add columns to an existing table.
2) Create Database tables.
3) Alter an IB_query to disconnect from one table and
connect to another.
4) Dynamically create IB_query's and IB_datasources.

The most pressing problem is 1), I believe the SQL
statement is

"ALTER TABLE MTCUSER ADD GRIDWIDTH SMALLNUMBER"

(SMALLNUMBER is a domain) but I don't know how to send
this to Interbase and get it executed from within my
program (I have tried with no success).

If anyone can recommend a book or better still send me
some code I would appreciate it.

Thank you

John Hart
Macquarie Training Centre Pty Ltd.


__________________________________________________
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions!
http://auctions.yahoo.com