1. EuSQL: Multiple Statements per Query?
- Posted by cklester <cklester at yahoo.com>
Dec 01, 2005
-
Last edited Dec 02, 2005
Matt, is it possible to issue multiple statements during a query? That is, can
I, with one query, create a database, its tables, and their fields?
-=ck
"Programming in a state of Euphoria."
http://www.cklester.com/euphoria/
2. Re: EuSQL: Multiple Statements per Query?
cklester wrote:
>
> Matt, is it possible to issue multiple statements during a query? That is, can
> I, with one query, create a database, its tables, and their fields?
No. You need to run them separately. I suppose that you could write a
routine to do this for you, looking for semi-colons (which are the standard
statement terminators for SQL) and running each statement separately.
Matt Lewis
3. Re: EuSQL: Multiple Statements per Query?
Matt Lewis wrote:
> cklester wrote:
> > Matt, is it possible to issue multiple statements during a query? That is,
> > can
> > I, with one query, create a database, its tables, and their fields?
> No. You need to run them separately. I suppose that you could write a
> routine to do this for you, looking for semi-colons (which are the standard
> statement terminators for SQL) and running each statement separately.
Yeah, I thought of that after I posted my message. It would be a simple
parse(myQuery,',') and then loop through that. I just didn't know what the
standard line terminator was. Thanks! :)
-=ck
"Programming in a state of Euphoria."
http://www.cklester.com/euphoria/
