Tim,

I tried to do a SQL script as SP but only the first statement is executed,
what am I doing wrong?

EXECUTE IMMEDIATE 'DROP TABLE "Categories";';
EXECUTE IMMEDIATE '
CREATE TABLE "Categories"
(
"CategoryID" GUID,
"CategoryName" VARCHAR(15) COLLATE "ANSI",
"Picture" BLOB,
CONSTRAINT "Check_CategoryName" CHECK "CategoryName" IS NOT NULL,
CONSTRAINT "PK_Categories" PRIMARY KEY ("CategoryID")
)
VERSION 1
UNENCRYPTED
INDEX PAGE SIZE 4096
BLOB BLOCK SIZE 512
MAX ROW BUFFER SIZE 32768
MAX INDEX BUFFER SIZE 65536
MAX BLOB BUFFER SIZE 32768;
';

Harry,

<< I tried to do a SQL script as SP but only the first statement is
executed, what am I doing wrong? >>

It works here.  Are you getting an error at all ?  You might want to try it
with the new build 5 coming out today.  It might have to do with some of the
issues with the last build in terms of parsing begin/end blocks in stored
procedures.

--
Tim Young
Elevate Software
www.elevatesoft.com