Re: Reverse engineering SQL

[T Lee Davidson <t.lee.davidson@xxxxxxxxx>]

On 3/25/25 7:46 PM, BB wrote:
> I think I have to manipulate the query string and eliminate the WHERE and ORDER BY clauses and add LIMIT=1 (to get a result back 
> in my lifetime! several million records). Will reply if it works.

Could you execute the full query and simply append a "WHERE 1<>1" to the end? That gives the filed names (at least with the 
Sqlite driver).


--
Lee

--- Gambas User List Netiquette [https://gambaswiki.org/wiki/doc/netiquette] ----
--- Gambas User List Archive [https://lists.gambas-basic.org/archive/user] ----