How do I create a SQL script with multiple statements?  In MySQL I can put multiple statements in a file separated with semicolons and run it.  Why can't I do that with the ElevateDB Manager?

Create a new script (Button "New | Script") and use

Execute Immediate 'sql-statement';
Execute Immediate 'sql-statement';
Execute Immediate 'sql-statement';

etc.

Matt

>How do I create a SQL script with multiple statements? In MySQL I can put multiple statements in a file separated with semicolons and run it. Why can't I do that with the ElevateDB Manager?

I assume that you're referring to a script as a simple list of sql statements as there was in DBISAM not a script as in a a program then the answer is that in EDBManager (not a query in a program unless you implement yourself) just use a ! to separate the statements. This can be changed in teh preferences (editor | statement termination character)

If you are referring to a script not a query then Uli has already given you the answer.

Roy Lambert

Thanks, you guys.  I knew there had to be a way to do it!