Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 3 of 3 total |
ALTER DATABASE |
Tue, Apr 3 2012 4:40 PM | Permanent Link |
Enrico Pettenati | 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 |
Wed, Apr 4 2012 3:43 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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] |
Thu, Apr 5 2012 2:29 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
This web page was last updated on Sunday, May 5, 2024 at 07:30 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |