How to access a kbmmemtable table in addition to the existing ADO Database tables

rbuser

Hi

Delphi 6 Pro
RB 7.04 Enterprise/ RB 10 Server (possible upgrade to 11 in the near future)
XP Pro

Currently all my reports are setup to link to MSAccess or SQL Server via ADO
but I now have an added requirement to have access to a kbmMemTable
containing a list of Customer Accounts. Is it possible to ideally add the
memTable to the 'Data' tab so that it shows under the 'Available Tables' so
it can be used in the normal way. If yes then how would I best achieve this
otherwise is there an alternative approach I could take.

Thanks

Stuart Barrett
GSD Associates Ltd.

nicocizik

Hi Stuart,

DADE does not support multiple database connection types. One option would
be to access all your data from memory tables such as kbmMemTables removing
the need to access your Access or SQL Server database directly from
ReportBuilder. Another would be to connect to the kbmMemTable manually in
Delphi without the use of DADE (using datapipelines).

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Thanks Nico

I thought this might be the case. Unfortunately using kbmMemTables for all
Reports would be a major undertaking at this point and manually connecting
the MemTable using DataPiplelines would effectively tie particular reports
to the application which I was hoping to avoid.

Just another thought is if I had a dummy Table in the Access/SQL Server
Database which would purely be used when in the the DADE could I then
identify which DataPipeline had been associated with the said table and them
override it after the template has been loaded and before the report is
printed so that it accesses it's data from the memTable (I reallise I may
need to use a memTable which supports SQL) rather than the ADO Dataset .
Note I am using Report Templates saved to a database.

Thanks

Stuart

nicocizik

Hi Stuart,

Unfortunately the dataview will still expect the pipeline to be connected to
an ADO dataset so I do not believe that will function correctly. The
easiest way would be to find a way to temporarily add this memory data to
your database as a temp table or view. This way you would have complete
access to it as if it were always part of the main database.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com