[Gambas-user] SQLRequest (Q2 of 2) Actually a couple of questions/wishes

[bb]

On Sat, 2021-07-03 at 02:06 -0500, John Dovey wrote:
> 
> I don’t understand this. I do that routinely with SQLite with a
> simple $con.exec(MySQL)
> and up to around a hundred sql statements concatted together in
> MySQL. Just do a $con.begin before and $con.commit after.
> 
> 
> On Fri, Jul 2, 2021 at 3:05 PM bb <adamnt42 at gmail.com> wrote:
> > 6. Uniting a whole bunch of SQLReqests, separated by ";" for
> > submission
> > to the server as a "script"?
> > 
> > regards
> > bruce
> > 
> > 
Ah John, you missed my point. These are suggestions for enhancement of
the SQLRequest class in gb.db, not a "How do I".

I am looking at ways to implement dynamic SQL*. At the moment
SQLRequest only copes with simple single table requests.

BTW you can use it (as it is) with the (pseudo-code) construct:

	Dim hSQL as new SQLRequest
	Dim hRlt as Result
	hRlt = MyConn {or} DB {or} Connections["xyz"].Exec(
hSQl.Select(blah blah).From(blah blah).Where(blah blah) )

regards
bruce

* No comments needed on "dynamic SQL" thanks.