Reportbuilder 10.02
Delphi 7
Table DBISAM 3.26  windows XP home
.................................
My app is producing invoices and salary for an artseller.
>: exhibition >> items
It has been working fine for 4 years.
Suddenly the app makes no invoices from the last exhibition, salary however comes fine.
All the former exhibitions does report both invoices and salary. A fake new exhibition produces no invoices.
- The problem appears also in Design mode of the Reportbuilder.
The invoice is totally empty, no design items, no table-stuff.
The item table is controlled. Where is the solution?
Thor, Norway

Thor,

<< Suddenly the app makes no invoices from the last exhibition, salary
however comes fine. All the former exhibitions does report both invoices and
salary. A fake new exhibition produces no invoices. - The problem appears
also in Design mode of the Reportbuilder. The invoice is totally empty, no
design items, no table-stuff.  The item table is controlled. Where is the
solution? >>

Did you try verifying all of the involved tables ?  I suspect that the
problem is index corruption.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim
Yes, I have veryfied both tables, apparently no corruptions.
Still both reports works fine for the former exhibitions.
But the recent exhibition (nr 25):
-  the salary report appears fine.
-  the invoice report is empty.

And I am getting lots of grey hairs.
Thor
(Vista + D7 + DBISAM 3,26)


"Tim Young [Elevate Software]" wrote:

Thor,

<< Suddenly the app makes no invoices from the last exhibition, salary
however comes fine. All the former exhibitions does report both invoices and
salary. A fake new exhibition produces no invoices. - The problem appears
also in Design mode of the Reportbuilder. The invoice is totally empty, no
design items, no table-stuff.  The item table is controlled. Where is the
solution? >>

Did you try verifying all of the involved tables ?  I suspect that the
problem is index corruption.

--
Tim Young
Elevate Software
www.elevatesoft.com

Thor


First ignore wether it verifies or not. Try repairing it and see if that sorts things out. If not you'll have to insert breakpoints in your code and see what's going on.

Roy Lambert [Team Elevate]

Repair is also done.
The performance is just incredible. Two reports (invoice and salary) worked fine on the tables (exhibitions >> items) from exhibition 1 till 24. Then the invoice report produces nothing. The salary works fine.
OK, I will set a breakpoint and see.
Thor

Roy Lambert wrote:

First ignore wether it verifies or not. Try repairing it and see if that sorts things out. If not you'll have to insert breakpoints in your code and see what's going on.

Roy Lambert [Team Elevate]

Thor

>Repair is also done.
>The performance is just incredible. Two reports (invoice and salary) worked fine on the tables (exhibitions >> items) from exhibition 1 till 24. Then the invoice report produces nothing. The salary works fine.
>OK, I will set a breakpoint and see.

Without knowing how you produce your reports I can't offer much advice. However, my first thought would be to look at the data in DBSys. Is it actually there, is it correct? You said <<The item table is controlled>> I assume you mean in a master-detail relationship? If so are the linking fields set correctly? I assume you're either using a filter or sql. When debugging make sure it is right - I've often left some bit of code in which has come back to bite me.

Roy Lambert [Team Elevate]

Roy Lambert wrote:
Back on track again.  Still deeply confused.
Viewed the data in DBSYS, Everything looks normal.
Invoicing works fine for exhibition 1-24, exhibition 25 provides NOTHING.
Watch 2 enclosed photos.
Thor

Thor

>Repair is also done.
>The performance is just incredible. Two reports (invoice and salary) worked fine on the tables (exhibitions >> items) from exhibition 1 till 24. Then the invoice report produces nothing. The salary works fine.
>OK, I will set a breakpoint and see.

Without knowing how you produce your reports I can't offer much advice. However, my first thought would be to look at the data in DBSys. Is it actually there, is it correct? You said <<The item table is controlled>> I assume you mean in a master-detail relationship? If so are the linking fields set correctly? I assume you're either using a filter or sql. When debugging make sure it is right - I've often left some bit of code in which has come back to bite me.

Roy Lambert [Team Elevate]

Roy

And here is the screen dump from report 25.
Thor

Roy

And here is the data. 2 files

Roy
And the index file