Page 1 of 1
SQL Query Builder For MS SQL
Posted: Sat 23 Sep 2006 10:24
by mhanefitel
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.
Posted: Mon 25 Sep 2006 10:55
by Jackson
Try FastReport components:
http://www.fast-report.com.
Where is SDAC Component in Fast Query Builder.
Posted: Mon 25 Sep 2006 12:48
by mhanefitel
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.
Posted: Wed 27 Sep 2006 15:06
by Antaeus
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:
Problem with the Fast Query Builder Dialog's engine property.
Posted: Thu 28 Sep 2006 07:55
by mhanefitel
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...
Posted: Fri 29 Sep 2006 14:04
by Antaeus
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.
The problem is still the same.
Posted: Sat 30 Sep 2006 08:52
by mhanefitel
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...
My problem is urgent.
Posted: Tue 03 Oct 2006 09:56
by mhanefitel
Hi Core Lab Team,
My problem is urgent and i need quick help.
Thanks in advance...
Posted: Tue 03 Oct 2006 10:20
by Antaeus
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.