> I only want to use CR to read a simple table from my DB.

Create a view which returns the data you need. This is the preferred method, as it abstracts the needed data from its actual representation in the database. It's comparable to interfaces in programming languages.

Rick DeBay

-----Original Message-----
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of diegodelafuente
Sent: Wednesday, April 12, 2006 10:24 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: Crystal Report

--- In firebird-support@yahoogroups.com, "lysander4444"
<lysandersyahooadress@...> wrote:

>
> --- In firebird-support@yahoogroups.com, "Graeme Edwards"
> <g.edwards@> wrote:
>
> > Crystal reports has the structure for making complex joins between
> tables
> > anyway, so you may just be able to create the necessary joins
> >
> > to extract your data without stored procedures or views.
>
> Yes, but that usually is by far slower than building the resultset on
> the firebird server by a selectable stored proc and let CR just read
> the results.
>

And in SQL2000 you can user arrays instead of Temp Files.
That is faster than the orher ways.

I don´t like to use CR for make joins or something else, because when a new version of CR arrives, I must check anything again.
I only want to use CR to read a simple table from my DB.






++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links