Hello,
Does DEVART has a visual tool to be added to Delphi XE5 which help building and designing sql queries for end users?
Thank you
Visual Query Builder
Re: Visual Query Builder
Please specify what exactly you mean by designing sql queries for EntityDAC. Maybe you mean other Devart DAC products
(UniDAC, ODAC, SDAC, etc.). Please note that the functionality you are interested in is present in the product line of our dbForge Studio products : devart.com/dbforge/
If the described functionality is required in DAC products, you can leave your suggestions at our UserVoice page
( https://devart.uservoice.com/forums/104 ... components ), and if there are many votes for your suggestion, we will implement it.
(UniDAC, ODAC, SDAC, etc.). Please note that the functionality you are interested in is present in the product line of our dbForge Studio products : devart.com/dbforge/
If the described functionality is required in DAC products, you can leave your suggestions at our UserVoice page
( https://devart.uservoice.com/forums/104 ... components ), and if there are many votes for your suggestion, we will implement it.
Re: Visual Query Builder
Hello,
Sorry being so late.
I think this post would have been better placed in the UnDAC section, but anyway...
The idea is to be able to create an application which allows an enduser to connect to a specific database system and view all tables and views and their fields; from here to be able to visually drag'n'drop these components to create queries for getting out data is interested in.
Something like the way of designing views in MS SQL Studio.
Thank you.
Sorry being so late.
I think this post would have been better placed in the UnDAC section, but anyway...
The idea is to be able to create an application which allows an enduser to connect to a specific database system and view all tables and views and their fields; from here to be able to visually drag'n'drop these components to create queries for getting out data is interested in.
Something like the way of designing views in MS SQL Studio.
Thank you.
Re: Visual Query Builder
Thank you for the suggestion. Currently, our DAC products support integration with the following tools:
- dbForge Studio for SQL Server
- dbForge Studio for MySQL
- dbForge Studio for Oracle
Soon we are planning to add the integration with dbForge Studio for PostgreSQL. DbForge Studio includes Query Builder, with which you can compose SQL queries as you want and use them in the Delphi application developed by you. We will take into account your wishes for further development of our products.
- dbForge Studio for SQL Server
- dbForge Studio for MySQL
- dbForge Studio for Oracle
Soon we are planning to add the integration with dbForge Studio for PostgreSQL. DbForge Studio includes Query Builder, with which you can compose SQL queries as you want and use them in the Delphi application developed by you. We will take into account your wishes for further development of our products.
Re: Visual Query Builder
I think what the OP was asking for was a way to visually create some queries in the LINQ query editor.
I have to admit, I have had a number of challenges myself in trying to figure out the differences between the LINQ syntax in Delphi Code verses in the LINQ query text editor.
For me, it would be cool if there was an intellisense-style helper in there, so as a developer it's easier to see options as we type our queries into the editor. :-)
Thanks for listening.
I have to admit, I have had a number of challenges myself in trying to figure out the differences between the LINQ syntax in Delphi Code verses in the LINQ query text editor.
For me, it would be cool if there was an intellisense-style helper in there, so as a developer it's easier to see options as we type our queries into the editor. :-)
Thanks for listening.
Re: Visual Query Builder
We plan to unify the LINQ syntax used in the query editor with the one used in Delphi code. This will help to avoid differences and difficulties in writing queries. We will add this functionality in one of the next EntityDAC builds.