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

[bb]

On Sat, 2021-07-03 at 11:15 +0200, Fabien Bodard wrote:
> Hi Bruce ,
> 
> So you want something like 'In'
> 
> I think the good way may look like
> 
> hMyNewRequest.In(OtherOne)
> 
> or .With(OtherOne)
> 
> Request Is a simple constructor not really a true function. It allow
> to modify easily part of a requisition.. more than modifying a sql
> request string.
> 
> But something like the MS request class will be cool.
> 
> ----[ http://gambaswiki.org/wiki/doc/netiquette ]----

Both In and With are reserved words. 

For 2. I could envisage something like 
hSQLRequest.CTE(sqlRequestxyz as SQLRequest).Select(...
where sqlRequestxyz is a previously instantiated SQLRequest

For 6. I dont know, maybe "Compose"
hSQLRequest.Compose(Begin(),q1,q2,q3,Commit()[ Rollback() ])
where each previously created q1,q2 and q3 SQLRequest objects (ie the
string version thereby created) are included, delineated by a ";".

That way the entire transaction could be executed by 
hResult = Conn.Exec(hSQLRequest.Compose(....))
or
bResult = Conn.Exec(hSQLRequest.Compose(....))


b