Subject | Re: Script sql for firebird |
---|---|
Author | Svein Erling |
Post date | 2004-02-25T14:22:01Z |
> From an absolute beginner....Click on the 'Execute script' button on the Connection tab of IB_SQL.
> 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".
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 seemTIME is a datatype that only exists if using dialect 3. If you are
> to be unknown.
using dialect 1 then only DATE is available, and DATE in dialect 1 is
the equivalent of TIMESTAMP in dialect 3.
HTH,
Set