At 01/20/2002 03:11 PM (Sunday), Duilio Foschi wrote:

>what do you do when creating a new database ? Do you add tables, indexes,
>triggers and costraints one by one using IB_SQL or the like ? Or do you
>create a big script that does everything ?

I create a set of script files which can be run to re-create the empty
database. I then add a set which populate the database with relatively
static lookup data records.

>how can I run several sql statements one after another from an SQL editor
>like WISQL ?
>
>I'd like to run several INSERTs at a time, like

Put them into a text file which starts with a CONNECT statement to connect
to the database. Add COMMIT statements where you want transactions to be
committed. Run the script from WISQL. This is what I do for the above
mentioned script to create a database.