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 ------------------------------------------------------------------------------ Dive into the World of Parallel Programming! The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user