![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 4 of 4 total |
![]() |
Tue, Jul 1 2014 11:58 AM | Permanent Link |
Matt Gregory | 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?
|
Tue, Jul 1 2014 2:53 PM | Permanent Link |
Uli Becker | Create a new script (Button "New | Script") and use
Execute Immediate 'sql-statement'; Execute Immediate 'sql-statement'; Execute Immediate 'sql-statement'; etc. |
Wed, Jul 2 2014 3:40 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | 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 |
Tue, Jul 8 2014 4:36 PM | Permanent Link |
Matt Gregory | Thanks, you guys. I knew there had to be a way to do it!
|
This web page was last updated on Wednesday, August 14, 2024 at 07:31 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |