Out of memory (Limitations of DADE/RB7)

rbuser

Hi,

I have a report that pull in a signifcant amount of fields (~215). 99% of
the se fields are varchar(4000). When I go to view my query I get an out of
memory error. What are the memory limitations of a query use DADE?

thanks

John Nolan

nardmoseley

ReportBuilder does not have any limitation.

Each DADE QueryDataView that you create is a container for the the
DBPipeline, TDataSource, and query based TDataSet descendant. For example,
if you are using ADO, then an ADOQueryDataView will contain an ADOQuery,
DataSource, and DBPipeline component. Any limitations you encounter are
limitations related to working with the ADOQuery or perhaps the particular
database product.

As a simple example, create a Delphi form and manually addd the data access
component to the form. Use the same SQL text statement that you are using in
the DADE query.

rbuser

Ahh thanks Nard.

Just put the query through ADO and its fine... until I display the results
in a TDBGrid and I get the out of memory error. I guess this is what is
happening as I get the Out of memory when I preview the query.

nardmoseley

Interesting, we have not had anyone report this before. Yes, RB uses TDBGrid
to display ths results in the query preview.