SQL Query Builder For MS SQL

mhanefitel · Post by **mhanefitel** » Sat 23 Sep 2006 10:24

Hi Core Lab Team,

I am looking very best query builder to give my end users to make their own queries very easly and then design their own reports to print out queried results.
Could you suggest me very best components to use for this purpose.
I use delphi 7, MS SQL 2000, 2005 and SDAC.
Thanks in advance.

Jackson · Post by **Jackson** » Mon 25 Sep 2006 10:55

Try FastReport components: http://www.fast-report.com.

mhanefitel · Post by **mhanefitel** » Mon 25 Sep 2006 12:48

Hi,
As far as i know, fast query builder does not support crlab's SDAC.
If it supports how to use it. Currently i am using fast report and fast query builder but i did not see any SDAC components on the fast query builder's pallette. I use adoconnection to access database because i could not find SDAC component.
Thanks in advance.

Antaeus · Post by **Antaeus** » Wed 27 Sep 2006 15:06

There is example of SDAC packages for FastReport in MyDAC FastReport demo. After compiling and installing these packages you will find SDAC for FastReport on FastReport tab sheet. This allows you to use SDACDatabase, SDACQuery, SDACTable in the FastReport designer. To enable QueryBuilder of FastReport you should find frx.inc file in FastReport installation directory and uncomment the following line in it:

Code: Select all

//{$DEFINE QBUILDER}

mhanefitel · Post by **mhanefitel** » Thu 28 Sep 2006 07:55

Hi Core Lab Team,

For the fast report designer there is no problem but for the Fast Query Builder; ıt is still not working.
I have done what you have written bu i could not succeed.
I installed Fast Query Builder, dclfrxSDAC7 package and then uncomment //{$DEFINE QBUILDER}.
Thera are two frx.inc files and i uncommented both. One is in the
C:\Program Files\FastReports\FastReport 3\LibD7 folder, and the other one
C:\Program Files\FastReports\FastReport 3\Source folder.
For the fast query builder dialog's engine property we need an engine but query builder dialog does not see the frxSDAC Component as an engine.
Am i missing something?

Thanks in advnce...

Antaeus · Post by **Antaeus** » Fri 29 Sep 2006 14:04

Try to recompile and reinstall SDAC for FastRepot after specified line is uncommented. If this will not help then report us version of FastReport you use.

mhanefitel · Post by **mhanefitel** » Sat 30 Sep 2006 08:52

Hi Core Lab Team,

I have done what you said but there is no solution. I use Delphi7,
SDAC 3.80.0.31, Fast Report 3.24.2.
Thanks in advance...

mhanefitel · Post by **mhanefitel** » Tue 03 Oct 2006 09:56

Hi Core Lab Team,

My problem is urgent and i need quick help.
Thanks in advance...

Antaeus · Post by **Antaeus** » Tue 03 Oct 2006 10:20

We tested SDAC with FastQueryBuilder in this March and no problems were found. We will examine this question deeply in the future.
You can make such components yourself using NewEngine utility from FastReport package. You will find this demo in %FastReport%\Extra\New DB engine directory\.
%FastReport% is the FastReport installation path on your computer.

Devart Forums

SQL Query Builder For MS SQL

SQL Query Builder For MS SQL

Where is SDAC Component in Fast Query Builder.

Problem with the Fast Query Builder Dialog's engine property.

The problem is still the same.

My problem is urgent.