Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
Create a Store Dynamically |
Tue, Mar 24 2009 6:09 AM | Permanent Link |
Peter Thorne | This will create OK:
CREATE PROCEDURE CreateBackupStore(IN "FolderLocation" VARCHAR) BEGIN DECLARE Stmt STATEMENT; PREPARE Stmt FROM 'CREATE STORE "Backups" AS LOCAL PATH ?'; EXECUTE Stmt USING FolderLocation; END; but it won't execute (throws a 700 error, not liking the parameter). Presumably (he says cautiously) there is a way of achieving the same result? Please advise. Many thanks as usual ... Peter |
Tue, Mar 24 2009 6:34 AM | Permanent Link |
Fernando Dias Team Elevate | Peter,
> Presumably (he says cautiously) there is a way of achieving the same > result? Yes, there is: CREATE PROCEDURE CreateBackupStore(IN "FolderLocation" VARCHAR) BEGIN EXECUTE IMMEDIATE 'CREATE STORE "Backups" AS LOCAL PATH ''' + FolderLocation + ''''; END; -- Fernando Dias [Team Elevate] |
Tue, Mar 24 2009 7:03 AM | Permanent Link |
Peter Thorne | "Fernando Dias" wrote:
< Yes, there is: CREATE PROCEDURE CreateBackupStore(IN "FolderLocation" VARCHAR) BEGIN EXECUTE IMMEDIATE 'CREATE STORE "Backups" AS LOCAL PATH ''' + FolderLocation + ''''; END; > Great. Thanks Fernando. |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |