Delphi中的SQL查询构建器 [英] SQL Query builder in Delphi

问题描述

我需要让用户能够针对我们的数据库构建简单的SQL查询。我们的应用程序是用Delphi编写的。

I need to give users the ability to build a simple SQL query against our database. Our application is written in Delphi.

我假设用户只有中等水平的知识，但他们需要能够构建简单的select语句才能查询对几张桌子。如果我可以轻松解决问题，那将是最奇妙的事情。

I am assuming only moderate levels of knowledge by the user, but they need the ability to build a simple select statement to be able to query against a couple of tables. If I can make this easy for them, that would be most wondrous.

有人知道我可以用来帮助用户构建的工具或一组组件吗？ SQL SELECT语句...

Does anyone know of a tool or a set of components that I can use to help the users build SQL SELECT statements...

推荐答案

我遇到过FastQueryBuilder http://fast-report.com/en/products/visual-query-builder.html
和
OpenQueryBuilder http://fast-report.com/ zh_cn / products / free-query-builder.html
（同一工具的明显不同版本），请参见Fast-Report。
看起来像是正确的主意。任何人都有经验吗？

I've come across FastQueryBuilder http://fast-report.com/en/products/visual-query-builder.html and OpenQueryBuilder http://fast-report.com/en/products/free-query-builder.html (apparently differing versions of the same tool) at Fast-Report. It looks like the right idea. Anyone have any experience with it?

这篇关于Delphi中的SQL查询构建器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！