Page 1 of 1

Viewing Query results into DBGrid

Posted: Fri 25 Dec 2009 09:33
by Geert De Coninck
Using C++ Builder 6 i have made some SQL string using Query Builder for MySQL.

I can run this SQL string in a Query component, so far no problem!

But this Query is linked to a DBGrid and this grid does not shows all fields from the Query, only the fields assigned from the source Table.

It is a SQL string combining 3 tables with inner joins.

Please advice how I can show my records with all the fields used in the Query.

Thanks :!:

Posted: Fri 25 Dec 2009 19:41
by Geert De Coninck
The Query shows all fields in object treeview. But when connecting the Query to DBGrid not all fields are shown, only the fields original from Table.

Posted: Sun 27 Dec 2009 20:48
by Geert De Coninck
:idea:
Problem solved
:!: