Copy without overridding existing columns

[granni]

Does anyone noe how to programmatically create columns? I'm trying to copy fields from 1 table to another, @ the same time creating some new columns in the target table.

Thanks In Christ Jesus

 

[PhilipOfOrange]

Here are two ways to do this:

1) Use COPY STRUCTURE EXTENDED to create a new table that contains the original structure, using one record to describe each field in the original. You can then append this table with the data for the new fields. Then use this table to create a new table with the original structure plus the added fields with the CREATE ... FROM command.

2) Programmatically create a new table using the SQL 'CREATE TABLE' command. You will need to plug that command into an executeSQL() method.