|
| SQLExec and query on the result |
| Iniciado por dj5f, 21,mar. 2020 20:05 - 1 respuesta |
| |
| | | |
|
| |
Miembro registrado
163 mensajes |
|
| Publicado el 21,marzo 2020 - 20:05 |
How can I query the result of a SQLExec ?
SQLExec("SELECT * FROM " + sTable, "Qry1")
sQry2 = "SELECT * FROM "Qry1" ?????????
HExécuteRequêteSQL("Qry2", gcnxHFSQL, sQry2) ??????
--
__________________
Denis Jobin
Longueuil, Québec |
| |
| |
| | | |
|
| | |
| |
Miembro registrado
194 mensajes |
|
| Publicado el 27,marzo 2020 - 16:01 |
Hi Denis
Why not simply a subquery, (either with SQLExec or HExecuteRequêteSQL) ?
SELECT ... FROM (SELECT ...)
Or when the problem is complex you can use "Procédure stockées" (Stock Procedure ?) on your SQL engine, more powerfull since you'll be able to use for instance temporary tables if needed.
--
Côme, Clairinfo |
| |
| |
| | | |
|
| | | | |
| | |
|