Hi all,
the solution is probably simple oversight but,
I want to create a simple program to update the structure of some tables,
and create new ones.

I put a IBODatabase, and a IB_script which contains a create table and
insert statements.

CREATE TABLE ABREVS (
A_CODE CHAR ( 2 )
, A_NAME CHAR ( 20 )
);
Commit;

/* provinces */
INSERT INTO ABREVS ( A_CODE, A_NAME )
VALUES ('AB','Alberta' );
INSERT INTO ABREVS ( A_CODE, A_NAME )
VALUES ('BC','British Columbia');
Commit;

this is a local database and connected set to true. all properties
(database name, password local...) are correct.

on a button click;

with updateServer do
ScUpdate.execute;

when I run I get error EIB_Statement Error
"Invalid Create, Connect or Drop Database syntax"

this is probably obvious to all of you, but I cannot see this error.

D5,FB1,IBO4.2Gb
Can someone help?
Thanks
Daniel







[Non-text portions of this message have been removed]