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

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]

"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.