Home DADE
New Blog Posts: Merging Reports - Part 1 and Part 2

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

edited November 2008 in DADE
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.

Comments

  • edited November 2008
    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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited November 2008
    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
  • edited November 2008
    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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.