Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 2 of 2 total |
BEGIN EXCEPTION |
Sat, Feb 2 2008 11:23 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Testing in EDBManager 1.07b3
I thought I'd try the BEGIN..EXCEPTION..END construct but it doesn't seem to work. If inFld isn't there the script works, with an error message (ElevateDB Error #401 The table inFld does not exist) on the status bar. If it is there it bombs out with "ElevateDB Error #400 The table infFld already exists" What am I doing wrong please. SCRIPT (IN TableWanted VARCHAR, IN DatabaseWanted VARCHAR) BEGIN BEGIN EXECUTE IMMEDIATE 'DROP TABLE inFld'; EXCEPTION END; EXECUTE IMMEDIATE REPLACE('$DB' WITH DatabaseWanted IN REPLACE('$TN' WITH TableWanted IN 'CREATE TABLE infFld AS SELECT ... LEFT OUTER JOIN "$DB".Information.IndexColumns XC ON XC.ColumnName = TC.Name AND XC.TableName = ''$TN'' WHERE TC.TableName = ''$TN'' GROUP BY Name WITH DATA')); EXECUTE IMMEDIATE 'CREATE INDEX "Name" ON "inFld" (Name)'; END Roy Lambert |
Sat, Feb 2 2008 11:33 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | And as so often after trying for ages and posting I spotted my fault inFld vs infFld - my new glasses should be ready next week
Not sure how that will help though since they're they same prescription. Roy Lambert |
This web page was last updated on Friday, May 3, 2024 at 08:07 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |