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

Matthew


In EDBManager File | Preferences | Editor | Statement Termination Character

its at the bottom

Roy Lambert

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

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

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

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

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