Anyone know of a component or tool to help us quickly make a visual query builder, for Win32 desktop Firemonkey?
Anyone know of a component or tool to help us quickly make a visual query builder, for Win32 desktop Firemonkey?
We need to make simple select statements from a fixed list of tables, the ability to select specific columns and provide aliases for them is important, and we need a reasonable level of flexibility with the WHERE clause (filtering and grouping). Given how much of what we want to do is 'on rails', we could build a complicated dialog with lots of dynamic clauses and what have you - but time is of the essence and money not necessarily a key factor.
There are a number of these kinds of things for the VCL - but the rest of our project is FMX and I'm not sure I want to try and get a VCL component shoe-horned into an FMX app (though I may look deeper into that).
We need to make simple select statements from a fixed list of tables, the ability to select specific columns and provide aliases for them is important, and we need a reasonable level of flexibility with the WHERE clause (filtering and grouping). Given how much of what we want to do is 'on rails', we could build a complicated dialog with lots of dynamic clauses and what have you - but time is of the essence and money not necessarily a key factor.
There are a number of these kinds of things for the VCL - but the rest of our project is FMX and I'm not sure I want to try and get a VCL component shoe-horned into an FMX app (though I may look deeper into that).
https://www.fast-report.com/en/download/fast-query-builder/
ReplyDeleteWe have used it in a programm written in Delphi 2007, worked fine.
Eli M Ooops, that's actually the one I meant.
ReplyDeleteThanks guys, will investigate further. :-)
ReplyDelete/sub
ReplyDeleteI haven't used it yet.. http://www.sqlmanager.net/en/products/tools/querybuilder
ReplyDelete