![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
![]() |
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 ![]() | 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 Wednesday, August 14, 2024 at 07:31 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |