[Gambas-user] SQLRequest (Q2 of 2) Actually a couple of questions/wishes
adamnt42 at gmail.com
Sat Jul 3 13:32:00 CEST 2021
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
> 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(....))
bResult = Conn.Exec(hSQLRequest.Compose(....))
More information about the User