Viewing Query results into DBGrid

Geert De Coninck · Post by **Geert De Coninck** » Fri 25 Dec 2009 09:33

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

Geert De Coninck · Post by **Geert De Coninck** » Fri 25 Dec 2009 19:41

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.

Geert De Coninck · Post by **Geert De Coninck** » Sun 27 Dec 2009 20:48

Problem solved