Home DADE

Is it possible to work with temporary tables

edited August 2006 in DADE
Hi,

I am using Delphi6 + SQL Server, and my RBuilder is 9.02.
I wonder if ReportBuilder could work with temporary tables (like #TabA,
##TabB) in SQL Server. Because when I am in Data tab of Design, I couldn't
see any temporary table.

Thank you!
Bin

Comments

  • edited August 2006

    The DADE plug-in is responsible for getting the list of available table
    names. If you are using ADO to connect to MS SQL Server, then you could try
    modifying the DADE plug-in for ADO. Open daADO.pas and find the method,
    TdaADOSession.GetTableNames. That method calls TADOConnection.GetTableNames,
    you would need to modify it to add a list of temp tables.


    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited August 2006
    Should I make change in daSQL.pas directly? If so, what project should I
    recompile and install after changing?

  • edited August 2006
    - /do not/ modify daSQL.pas (I never mentioned that unit)

    - /do/ modify daADO.pas (if you are using ADOSession type). Otherise you
    need to modify the relevant plug-in. You never specified what type of data
    connectivity you are using, so I just guessed that it was ADO to SQL Server.


    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited August 2006
    Sorry, my mistake. It is ADOSession type. So after modify daADO.pas, what
    should I recompile to make that into effect?
  • edited August 2006

    - when compiling set the Delphi library path to RBuilder\Source and then
    afterwards set it back to RBuider\Lib, set the output directories for dcp
    and bpl to be blank so that the new files will be generated to
    RBuilder\Source

    - I would first do a run-time test using the TppDesigner and get everything
    working correctly
    - then compile rbADO.dpk
    - after compiling you should have a new rbADO.dcp and rbADO.bpl, windows
    explorer to check the timestamp.
    - copy daADO.dcu to RBuilder\Lib
    - copy rbADO.dcp to RBuilder\Lib
    - exit Delphi and copy rbADO.bpl to Windows\System32
    - relaunch Delphi


    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited August 2006
    why I cannot find rbADO.dpk? My ReportBuilder is 9.02. I don't see a
    rbADO96.dpk either.
  • edited August 2006

    - email info@digital-metaphors.com with your serial number and registration
    information and request an update to RB 9.03, which was the last produced
    release for RB 9.x

    - install RB 9.03 and check RBuilder\Source for rbADO*.* and if no package
    source is installed then e-mail support@digital-metaphors.com with your
    Delphi version and RB versions and request it.


    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.