• derek
  • derek
  • Moderator
  • Offline
  • Registered: 2015-02-16
  • Posts: 2,955

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.

  • Registered: 2014-02-14
  • Posts: 10,294

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.
  • derek
  • derek
  • Moderator
  • Offline
  • Registered: 2015-02-16
  • Posts: 2,955

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.

4 Reply by jrga (edited by jrga 2025-08-06 15:15:38)

  • jrga
  • Member
  • Offline
  • From: Brasil
  • Registered: 2015-10-26
  • Posts: 196

Re: SQL Query and Tablegrid

The free version of Valentina Studio allows you to graphically build queries, which can be copied and pasted into MVD.

Post's attachments

Attachment icon valentina.png 126.62 kb, 7 downloads since 2025-08-06 

Roberto Alencar
  • Registered: 2014-02-14
  • Posts: 10,294

Re: SQL Query and Tablegrid

Thank you for the tip.

Dmitry.