Subject Creating Database tables and columns by program
Author John Hart

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


(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!