I need to alter a database.
I found to use a SQL config sequence or a more simple single line procedure. What's the better way ?

I tried to use the following procedure:
sPath := 'F:\Mydata';
with DataMain.DataModule1.EDBSession1s do Execute('ALTER DATABASE "MyDataBase PATH ' + sPath);

Can be a sintax error ?
using the following procedure al works correctly
with DataMain.DataModule1.EDBSession1 do Execute('ALTER DATABASE MyDataBase ' + 'PATH ''F:\MyData''');
Thanks

Enrico

>I tried to use the following procedure:
>sPath := 'F:\Mydata';
>with DataMain.DataModule1.EDBSession1s do Execute('ALTER DATABASE "MyDataBase PATH ' + sPath);

You seem to be missing the closing " after MyDataBase

Roy Lambert [Team Elevate]

Enrico,

<< I tried to use the following procedure:
sPath := 'F:\Mydata';
with DataMain.DataModule1.EDBSession1s do Execute('ALTER DATABASE
"MyDataBase PATH ' + sPath); >>

This is the correct way:

sPath := 'F:\Mydata';
with DataMain.DataModule1.EDBSession1s do Execute('ALTER DATABASE
"MyDataBase" PATH ' + Engine.QuotedSQLStr(sPath));

--
Tim Young
Elevate Software
www.elevatesoft.com