Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Public Beta Tests » View Thread |
Messages 1 to 2 of 2 total |
SQL scripts as SP: only first statement works |
Tue, Jan 9 2007 4:41 AM | Permanent Link |
"Harry de Boer" | 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; '; |
Tue, Jan 9 2007 8:29 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
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 |