Can I re-use an SQLQuery?

[AKCarlow]

Using:
OS-X 10.6.8
Lazarus 1.2.4, FPC 2.6.4
MySQL 5.6.19 (32-bit)

On a form I have a TDBText, TDataSource and TSQLQuery. In a separate data module I have a TSQLTransaction and TMySQL56Connection. The SQL query in the TSQLQuery is 'select count(acolumn) from thetable;'. It works.

However, what I would like to do is move the value in the TDBTExt to a static field, then change the query to 'select count(zcolumn) from othertable;' but I can't see how to copy the count from the TDBTExt.

I could of course put another set of TDBText, TDataSource and TSQLQuery for the second query, but as there will in fact be several of them I would prefer not to clutter up the form, or the data module, with multiple occurences.

Thanks for any suggestions.

[AKCarlow]

 
Ahh. I see it has a Caption property, not shown in the object inspector, which has the value I want.