Visual Query designer

sandy771 · Post by **sandy771** » Wed 10 Aug 2011 12:17

I want to provide my users the ability to query various tables within a database (currently sqlite - but as this is unidac that could change). Or rather I want to provide a visual query builder the output of which will be a valid sql string that i can pass to unidac.

Can anyone recommend something that will do this?

Thanks.

AlexP · Post by **AlexP** » Thu 11 Aug 2011 07:24

Hello,

Our DAC components, including UniDAC, are data access components and don't include visual components for working (building queries) with databases in the run-time mode. There are standalone applications for this purpose. You can create a query designer yourself using our components by getting metadata and creating queries basing on this data.

sandy771 · Post by **sandy771** » Thu 11 Aug 2011 08:00

AlexP wrote:Hello,

Our DAC components, including UniDAC, are data access components and don't include visual components for working (building queries) with databases in the run-time mode. There are standalone applications for this purpose. You can create a query designer yourself using our components by getting metadata and creating queries basing on this data.

Thanks Alex - I could also develop a DAC by writing my own code

I note that you do sell a query builder for sql server - is there any intention to do the same for unidac

I dont really want to re-invent the wheel, thats why I buy third party controls, can you or anyione else recommend a query builder that will work with unidac

AlexP · Post by **AlexP** » Thu 11 Aug 2011 11:52

Hello,

As UniDAC is designed for working with many different databases, we don't plan to create a unified query builder, because every database has its own peculiarities.