Query field headings

Hi,

Would it be possible to include - maybe as a toggle you can enable/disable?, the names of the table headings when you run queries. Sometimes the number of fields returned can be large and so keeping track of the tables they came from can be tricky - maybe as an extra row above the headings that shows each table name with a simple alternate shaded background, say light grey, light blue as so as you scroll across the results you can see which table the fields came from.

Regards.

Andy

Nice idea.

I am just adding a hint to the column headers, so the source table will pop up when you point your mouse it it:

Very nice! I appreciate it very much! But when there are column aliases in Cyrillic, there is no table name shown. And it does not appear at all, until before some hint with cell value is shown

P.S. And it shows only one name - that of the first table, the same one from the tab's name

Regarding the wrong table name issue you mention, that works here:

Though it might be that mysql_fetch_field_direct returns the wrong table name, not sure.

The issue of not displaying a hint until a cell shows a hint seems to be a long-time issue in VirtualTree: https://github.com/JAM-Software/Virtual-TreeView/issues/728

Sorry, it's not the same here. The server is MariaDB. It fails even with simple queries..

No problem. I just retested on MariaDB 11.1, and I realize that calculated or aggregated columns (like SUM(...) or FORMAT(...)) do not reveal their source table to the C API in mysql_fetch_field_direct . But non-aggregated fields are displaying their correct source table, even if the column name has cyrillic chars:

Dear Ansgar,

I, too, appreciate that new feature very much, and I was pleasently surprised to see how fast you were to pick up that proposal! Thanks a lot for your steady work even on tiny details

Thomas

Hey Thomas, thanks for your appreciation!

I was just testing if the rewritten Lazarus codebase has the same thing, and I see the VirtualTree issue does not exist - the tooltip shows quickly and without the need to click somewhere in the tree before.