Subject Re: Script sql for firebird
Author Svein Erling
> From an absolute beginner....
> Do you know how to send an SQL script for database creation into
> firebird or to update some table or stored proc. May be using a
> batch throw "ISQL".

Click on the 'Execute script' button on the Connection tab of IB_SQL.

Write something like

SET SQL DIALECT 3;

SET AUTODDL ON;

CREATE DATABASE 'c:\temp\test.fdb' user 'sysdba' password 'masterkey'
page_size = 4096 DEFAULT CHARACTER SET ISO8859_1;

commit;

Run this script and you're up and running.

> And I have some problem with IB_SQL and the datatype TIME that seem
> to be unknown.

TIME is a datatype that only exists if using dialect 3. If you are
using dialect 1 then only DATE is available, and DATE in dialect 1 is
the equivalent of TIMESTAMP in dialect 3.

HTH,
Set