Re: Reverse engineering SQL

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

On 3/22/25 9:34 PM, BB wrote:
> (not so trivial)
>
> Summary:
>
> Can anyone suggest
>
> 1) how to insert a string (of SQL) into an SQLRequest and have it parsed into an SQLRequest object

Something like SQLRequest.FromSql() ?

> or
>
> 2) have a Connection "compile" a string of SQL, not execute it just make the internals of a Result available for further use. 
> Sort of like

Something like, after executing the above, SQLRequest.Fields() ?

> I have some "fixed" query strings that I want to get into some structured object so I can do some manipulation of a grid I use 
> to display the results. Like setting the column count and headers. The query string is "incomplete" in that it has substitutable 
> WHERE clauses and ORDER BY clauses so I cant execute it at the time I am setting up the grid.
The only (and I'm sure not very helpful) suggestion I have is to initially set up the grid with an arbitrary number of columns 
and then correct that after the query/queries is/are actually executed.


--
Lee

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