My Visual Database — SQL Query and Tablegrid

Re: SQL Query and Tablegrid

null@example.com (DriveSoft) — Mon, 24 Sep 2018 18:43:49 +0000

Thank you for the tip.

Re: SQL Query and Tablegrid

null@example.com (jrga) — Mon, 24 Sep 2018 12:36:42 +0000

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

Re: SQL Query and Tablegrid

null@example.com (derek) — Tue, 14 Apr 2015 21:41:19 +0000

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

null@example.com (DriveSoft) — Tue, 14 Apr 2015 18:49:19 +0000

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

SQL Query and Tablegrid

null@example.com (derek) — Tue, 14 Apr 2015 18:29:58 +0000

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.