Custom SQL Text Editor/Visual Query Builder

ssmagin · March 2018

Hello,

Can you point me to the documentation how can I add a custom facility to let end-users edit SQL queries in the report designer? Basically, all I need is an event handler that will be fired when customer requests to edit a query. In this handler, I must get the current SQL text, display a dialog in which my query will be edited and pass the new/modified SQL query back to the report builder. Is it possible to do in Report Builder or is there a better way of integrating my text/visual SQL editor into the report designer?

Delphi: RAD Studio 10.2.3, Report Builder version: the latest, OS: Windows, Printer: doesn't matter.

Thank you in advance for prompt response.

nardmoseley · March 2018

HI Sergey,

RB includes built-in query tools.

RB cannot be used to build a query tool or a reporting tool. That is a violation of the license.

ssmagin · March 2018

Thank you, Nard.
Possibly I explained my question not very well.

I don't want to use RB to build a query tool, I don't have an intention to violate RB license.

I just I don't like the built-in "query tools" and I want to replace them with my custom SQL query builder. Is it possible?

nardmoseley · March 2018

Hi Sergey,

Thanks for the clarification.

The RB Data workspace is tightly coupled and is not open to integration.

Custom SQL Text Editor/Visual Query Builder

Comments