TppReportExplorer Recycle Bin Problem

rbuser

When you delete reports in the report explorer all it does is change the
folder id to "-2" in the folder table. It does not place any report into the
Recycle Bin Folder. So my users are asking me why the reports do not show
up in the recycle bin. I'm not sure what's going on. What should I look
for?

--
Michael Tuttle
Software Technologies, Inc.
Topeka, KS

nicocizik

Hi Michael,

Which version of ReportBuilder are you using? Are you able to recreate the
issue using our DBISAM end-user database demo? In my testing, the recycle
bin seemed to work correctly. You can see in the
TppReportExplorerForm.mniFileDeleteClick procedure inside the ppExpFrm.pas
file, the node is removed and UpdateRecycleBin is called, moving the report
to that folder.

--

rbuser

I am using Delphi 5.1 with IB Express components and RBuilder 6.03

I do not have DBISAM, but did hook in the End User IBExpress demo to my
database and the recycle bin works. The only thing I can think of is that
we are using a custom RB Explorer form. Any ideas?

Thanks

Mike

rbuser

I just upgraded to version 7 hoping that it would resolve this issue. It
did not. So still looking for suggestion of what I might look for.

Mike

nicocizik

Hi Michael,

I'm sorry, I don't know why I thought you were using DBISAM. Be sure that
all the code I mentioned in my previous post is currently in your custom
explorer, and is being executed properly. If possible, please send an
example of your application, including your custom explorer in .zip format
to support@digital-metaphors.com and I'll take a look at it for you.

--

rbuser

Nico,

We have resolved this matter. It was not a problem with RBuild at all,
instead when we created our own custom report explorer, we replace the
tables with TClientDatasets and should have included a LEFT OUTER JOIN in
our SELECT SQL. Sorry for any inconvenience this may have caused.

Here was our original SQL:

SELECT I.*,
F.NAME AS FOLDER_NAME
FROM RB_ITEM I
JOIN RB_FOLDER F ON F.FOLDER_ID = I.FOLDER_ID

Here is the corrected version:
SELECT I.*,
F.NAME AS FOLDER_NAME
FROM RB_ITEM I
LEFT OUTER JOIN RB_FOLDER F ON F.FOLDER_ID = I.FOLDER_ID

Thanks

Mike