Tim

I don't know where abouts or if its on the list but I'd like to add my voice to the clamour for multi line scripts. Take the following

CREATE TABLE "Transactions"
(
"_ID" INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 0, INCREMENT BY 1),
....
)
...
MAX BLOB BUFFER SIZE 32768;

CREATE INDEX "Cite" ON "Transactions"
("_Cite" COLLATE "ANSI_CI");

CREATE INDEX "Analysis" ON "Transactions"
("_Analysis" COLLATE "ANSI_CI");
 
As part of my apps these days I check for the existence of the tables and create if necessary. I now have to maintain separate items and fire separate queries to do what used to take one. This by the way is a simple case but even this table will have 4 indices and two triggers meaning running 7 queries, and unless I devise a storage/extraction scheme 7 separate stores.

Roy Lambert

Roy,

<< I don't know where abouts or if its on the list but I'd like to add my
voice to the clamour for multi line scripts. >>

I understand, and it's on the list as it always has been.

--
Tim Young
Elevate Software
www.elevatesoft.com