This component allows you to use EDB tables and queries in Fastreport's
design screens.  It was created by Terry Swiers.  The files are for EDB
2.02 and Delphi 2006, but it's not difficult to adapt them for other
versions.

Charles,

<< This component allows you to use EDB tables and queries in Fastreport's
design screens.  It was created by Terry Swiers.  The files are for EDB 2.02
and Delphi 2006, but it's not difficult to adapt them for other versions. >>

Thanks very much (and to Terry .

--
Tim Young
Elevate Software
www.elevatesoft.com

Charles,

> This component allows you to use EDB tables and queries in Fastreport's
> design screens.  It was created by Terry Swiers.  The files are for EDB
> 2.02 and Delphi 2006, but it's not difficult to adapt them for other
> versions.

I'm glad that you were able to find the component and post it.  I've been so
busy with my current project that I had not even had a chance to figure out
which virtual machine I had these installed on.

--

---------------------------------------
 Terry Swiers
 Millennium Software, Inc.
 http://www.1000years.com
 http://www.atrex.com

 Atrex Inventory Control/POS -
    Big business features without spending big business bucks!

Atrex Electronic Support Options:
 Atrex Knowledgebase: http://www.atrex.com/atrexkb.asp
 Email: mailto:support@atrex.com
 Newsgroup: news://news.1000years.com/millennium.atrex
 Fax: 1-925-829-1851
 Phone: 1-925-828-5892 (M-F, 9a-5p Pacific)
 ---------------------------------------

The Fastreport EDB query & table components as posted require you to
type in the SessionName and DatabaseName.  The following changes in
frxEDBEditor.pas will give you a dropdown list to select from.

(I barely understand how this works, so feel free to point out my
dunderheaded errors)


1. Locate the existing lines...

procedure TfrxSessionNameProperty.GetValues;
begin
//>>>  Sessions.GetSessionNames(Values);
end;

....and replace them with...

procedure TfrxSessionNameProperty.GetValues;
begin
  Engine.GetSessionNames( Values );
end;


2. Locate the existing lines...

procedure TfrxDataBaseNameProperty.GetValues;
begin
  inherited;
//>>>   Session :=
Sessions.FindSession(TDBDataSet(TfrxCustomDataset(Component).DataSet).SessionName);
//  if Session <> nil then
//    Session.GetAliasNames(Values);
end;

....and replace them with...

procedure TfrxDataBaseNameProperty.GetValues;
var aSession: TEDBSession;
begin
  inherited;
  aSession :=
Engine.FindSession(TEDBDBDataSet(TfrxCustomDataset(Component).DataSet).SessionName);
  if aSession <> nil then
    aSession.GetDatabases( Values );
end;

Charles

Thank you for your post. I will check it out on Delphi 2007 now. Thanks again. You saved me much time and troubles

Charles Tyson wrote:

This component allows you to use EDB tables and queries in Fastreport's
design screens.  It was created by Terry Swiers.  The files are for EDB
2.02 and Delphi 2006, but it's not difficult to adapt them for other
versions.

I would like to share the component I borrowed from Charles ( which was created from Terry).

I made some changes and I tested it successfully with Delphi 2007, EDB 2.03, and FastReport version 4.8.

The changes where only made to eliminate compilers errors as the initial code was made for different versions.

Thanks again for the code. I hope that sharing this code will save time to some other programmers.


Charles Tyson wrote:

This component allows you to use EDB tables and queries in Fastreport's
design screens.  It was created by Terry Swiers.  The files are for EDB
2.02 and Delphi 2006, but it's not difficult to adapt them for other
versions.

I maybe a little late to the game but I would also like to add my thanks for this excellent component! For those like me still dealing with legacy systems in Delphi 7 and looking for an alternative reporting module, I have found FastReports a much better alternative than others I have looked at. So in the spirit of the other contributors to this thread, I have included the files needed to get it running under D7, FastReports 4.14.3 and Elevate 2.12.2. I have not made any changes to the source code just the DPK and DCU files to get it running.

Thanks once again Charles/Terry/Tasos and anyone else, this is a life saver!


Regards

Edward Jones
NVS Ltd UK

------

[Tasos Savva wrote:

I would like to share the component I borrowed from Charles ( which was created from Terry).

I made some changes and I tested it successfully with Delphi 2007, EDB 2.03, and FastReport version 4.8.

The changes where only made to eliminate compilers errors as the initial code was made for different versions.

Thanks again for the code. I hope that sharing this code will save time to some other programmers.


Charles Tyson wrote:

This component allows you to use EDB tables and queries in Fastreport's
design screens.  It was created by Terry Swiers.  The files are for EDB
2.02 and Delphi 2006, but it's not difficult to adapt them for other
versions.]

Charles Tyson wrote:

This component allows you to use EDB tables and queries in Fastreport's
design screens.  It was created by Terry Swiers.  The files are for EDB
2.02 and Delphi 2006, but it's not difficult to adapt them for other
versions.
-----------------------
Can anyone provide an example of a project that included the use of the FastReport frxEDBComponents component in use.  I have installed the component in my Delphi XE and am using ElevateDB 2x in client/server application.  Despite the component being installed, I am unable to see the Table or Query fields at design time.  I am tired of beating my head against the wall and hoped that someone who used the component could drop a simple example in the binaries.  I think it might have something to do with Session/DatabaseName settings for a client/server environment.  I normally set these at run time.

Thanks,
... Norm