Topic: SQL Query and Tablegrid

Good Evening Dmitry and MVD Team,
If I use footer settings in a tablegrid (for example, 'SUM' with a prefix of '£'), these are displayed correctly.
If I use a SEARCH and specify the tablegrid for the output, the footer settings are still displayed correctly.
But if I write an SQL Query and specify the same tablegrid for the output, the footer settings are not shown.
Is there perhaps something else I need to use?
I know that I can correct this using a script but it is not so quick or so easy.
I am using 1.50 but I also noticed the problem in versions 1.45 and 1.49.
Thanks,
Derek.

Re: SQL Query and Tablegrid

Hello,


Thank you for the idea.
I made some changes, now you can set up footer using settings of TableGrid, then use button "SQL query"


Please, download latest beta version:
https://www.dropbox.com/s/vz1fmz5lrb6fw … 1.zip?dl=0

Dmitry.

Re: SQL Query and Tablegrid

Hello Dmitry,
I've just dowloaded the latest 1.51.  Footer settings are working well now with SQL QUERY searches. 
Thanks, as always,
Derek.

Re: SQL Query and Tablegrid

A versão free do  Valentina Studio permitir construir graficamente querys, que podem ser copiados e colados no MVD.

Roberto Alencar

Re: SQL Query and Tablegrid

Thank you for the tip.

Dmitry.