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

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]

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

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

Fernando,
Uli,

You guys are great.  Thanks for the help...


Regards,
Abdulaziz Jasser

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]

Fernando,

For sure I will consider that.  Thanks again.


Regards,
Abdulaziz Jasser

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

Abdulaziz,

> You can't. Use a script like this:

Like Fernando posted, I was wrong. You *can*.

Uli

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]