Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General Discussion » View Thread |
Messages 1 to 7 of 7 total |
Best scripting mechanism? |
Tue, Nov 14 2017 4:45 AM | Permanent Link |
Matthew Jones | So I have two SQL "commands" to run. I need to store them in a text file. Do I just pick my own delimiter and run them individually, or is there some standard, or an existing way to say "I have a string list, run everything here"?
-- Matthew Jones |
Tue, Nov 14 2017 5:21 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Matthew
In EDBManager File | Preferences | Editor | Statement Termination Character its at the bottom Roy Lambert |
Tue, Nov 14 2017 5:27 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Matthew
If you mean in your own program there is a facility to convert from DBISAM style scripts to ElevateDB style but I've never used it and can't remember where it is. I think it converts the script into a series of EXECUTE IMMEDIATEs I wrote my own DBISAM style sql script runner with a display to tell the user somethings going on. If you want a copy let me know. Roy Lambert |
Tue, Nov 14 2017 5:41 AM | Permanent Link |
Matthew Jones | Roy Lambert wrote:
> If you mean in your own program there is a facility to convert from DBISAM style scripts to ElevateDB style but I've never used it and can't remember where it is. I think it converts the script into a series of EXECUTE IMMEDIATEs > > I wrote my own DBISAM style sql script runner with a display to tell the user somethings going on. If you want a copy let me know. Thanks - I will use ! as well. I have to parse the file a little anyway, so I will just Split it into the sections and run .Execute on them (or whatever it is). If it doesn't work out, I'll be back! 8-) -- Matthew Jones |
Tue, Nov 14 2017 6:45 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Matthew
>Thanks - I will use ! as well. I have to parse the file a little anyway, so I will just Split it into the sections and run .Execute on them (or whatever it is). If it doesn't work out, I'll be back! 8-) That will work in EDBManager. If you need it for program execution have a look at EDBScript.ConvertSQL - an extra cup of coffee sparked memory Roy |
Thu, Nov 16 2017 1:02 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< If you mean in your own program there is a facility to convert from DBISAM style scripts to ElevateDB style but I've never used it and can't remember where it is. I think it converts the script into a series of EXECUTE IMMEDIATEs >> There's a method in the TEDBScript component for this, but it's also in the EDB Manager under: Script/Convert Into Script The only requirement is that you have a *script* window open, not a statement window. Tim Young Elevate Software www.elevatesoft.com |
Fri, Nov 17 2017 4:15 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
>There's a method in the TEDBScript component for this, but it's also in the EDB Manager under: > >Script/Convert Into Script > >The only requirement is that you have a *script* window open, not a statement window. Its nice to be able to learn new things at my age Roy |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |