Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General Discussion » View Thread |
Messages 1 to 10 of 10 total |
Execute a multi alters using EDB Manager. |
Tue, Sep 25 2012 1:05 PM | Permanent Link |
Abdulaziz Al-Jasser | Hi,
In DBISAM3 I can run multiple SQL clauses using Database system utility separated by semicolon. But I get an error on the second line if I try to run the same multiple lines script in EDB Manager. Can this be done in EDB Manager? Sample: ALTER TABLE TB_AccountsChart ALTER COLUMN AccountAddress AS VARCHAR(1024); ALTER TABLE TB_BranchSetup ALTER COLUMN InvoiceEndText AS VARCHAR(100); ALTER TABLE TB_CarsOwners ALTER COLUMN Address AS VARCHAR(1024); ALTER TABLE TB_CarsSetup ALTER COLUMN DeliveryTerms AS VARCHAR(200); Regards, Abdulaziz Jasser |
Tue, Sep 25 2012 1:45 PM | Permanent Link |
Fernando Dias Team Elevate | Abdulaziz,
Yes, you can. But the default statement terminator character is not ";" but "!" . You can also change the terminator character at Edit/Preferences/Editor if you want. -- Fernando Dias [Team Elevate] |
Tue, Sep 25 2012 1:45 PM | Permanent Link |
Uli Becker | Abdulaziz,
You can't. Use a script like this: SCRIPT BEGIN Execute Immediate 'ALTER TABLE TB_AccountsChart ALTER COLUMN AccountAddress AS VARCHAR(1024)'; Execute Immediate 'ALTER TABLE TB_BranchSetup ALTER COLUMN InvoiceEndText AS VARCHAR(100)'; .... END |
Tue, Sep 25 2012 1:48 PM | Permanent Link |
Uli Becker | Fernando,
> Yes, you can. > But the default statement terminator character is not ";" but "!" . > You can also change the terminator character at Edit/Preferences/Editor I just wrote "You can't". Actually you can write multiple statements separated by a terminator, but you can only execute one of them. Uli |
Tue, Sep 25 2012 1:55 PM | Permanent Link |
Abdulaziz Al-Jasser | Fernando,
Uli, You guys are great. Thanks for the help... Regards, Abdulaziz Jasser |
Tue, Sep 25 2012 1:58 PM | Permanent Link |
Fernando Dias Team Elevate | Uli,
<< Actually you can write multiple statements separated by a terminator, but you can only execute one of them.>> Only if you select *exactly* one statement in the left gutter. Otherwise all the selected statements are going to be executed, or if none selected all the statements are executed. BTW Abduaziz, if you want to change the terminator character, do *not* use ";" as it might cause issues with some statements. -- Fernando Dias [Team Elevate] |
Tue, Sep 25 2012 2:08 PM | Permanent Link |
Abdulaziz Al-Jasser | Fernando,
For sure I will consider that. Thanks again. Regards, Abdulaziz Jasser |
Wed, Sep 26 2012 2:17 AM | Permanent Link |
Uli Becker | Fernando,
> Only if you select *exactly* one statement in the left gutter. > Otherwise all the selected statements are going to be executed, or if > none selected all the statements are executed. Ups, I didn't know (and have never used) that. Thanks for the clarification! Regards Uli |
Wed, Sep 26 2012 3:11 AM | Permanent Link |
Uli Becker | Abdulaziz,
> You can't. Use a script like this: Like Fernando posted, I was wrong. You *can*. Uli |
Wed, Sep 26 2012 9:55 AM | Permanent Link |
Fernando Dias Team Elevate | Uli,
<< I was wrong. You *can*. >> Yes, but your suggestion of using dynamic SQL in a script is also correct and a good alternative as it would work not only in EDB Manager but also it could be used in any application. -- Fernando Dias [Team Elevate] |
This web page was last updated on Thursday, May 23, 2024 at 07:54 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |