Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 2 of 2 total |
Multiline scripts |
Sat, Mar 10 2007 8:45 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Mon, Mar 12 2007 4:57 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |