I think our mails crossed in transit. Anyway...
The SQL query used to obtain the Result should essentially be:
"SELECT * FROM " & DataSource.Table & " WHERE " & DataSource.Filter
So, it can actually be determined by calculation, or maybe more correctly stated, by concatenation.
The data control would then determine which of all columns are actually displayed.
Lee
__________
"Artificial Intelligence is no match for natural stupidity."
On 01/06/2015 01:28 AM, Lewis Balentine wrote:
> YEP --- that was the problem. I completely missed "is a container". In
> MS VB5/6 you only needed to place the Datasources on the same form ....
> actually not even that: you could build a connection or selection set
> and reference that.
>> One thing I would like to see is the ability to return the SQL Query
> actually used to obtain the "Result". This would be very helpful when
> trying to figure out why something did not work like one expected it to.
> I have used the "Subst" function to build such a string but there is
> always the nagging doubt that it is not exactly the same via some way
> Gambas handles substitutions or (more likely) I made a typo in
> duplicating the process.
>> Thanks for you help LEE.
>> Regards,
>> Lewis