|Subject||Re: [IBO] Creating Database tables and columns by program|
> >From within a program I need toIB_Script - just put the SQL in and execute it.
> 1) Add columns to an existing table.
> The most pressing problem is 1), I believe the SQL
> statement is
> "ALTER TABLE MTCUSER ADD GRIDWIDTH SMALLNUMBER"
> 2) Create Database tables.As above - look at the samples, Jason creates all the new
tables he needs 'On the fly'
> 3) Alter an IB_query to disconnect from one table andJust change the IB_Connection entry in IB_Query. You will
> connect to another.
need both databases connected to different IB_Connection
components. Alternative is just change the
> 4) Dynamically create IB_query's and IB_datasources.Not something I do myself - I use Builder anyway.
> If anyone can recommend a book or better still send mehttp://www.ibphoenix.com/60sqlref.html for the SQL stuff
> some code I would appreciate it.
ANY of the samples in the IBO directory
L.S.Caine Electronic Services