Is it possible to work with temporary tables

rbuser

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

nardmoseley

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

rbuser

Should I make change in daSQL.pas directly? If so, what project should I
recompile and install after changing?

nardmoseley

- /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

rbuser

Sorry, my mistake. It is ADOSession type. So after modify daADO.pas, what
should I recompile to make that into effect?

nardmoseley

- 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

rbuser

why I cannot find rbADO.dpk? My ReportBuilder is 9.02. I don't see a
rbADO96.dpk either.

nardmoseley

- 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