Re: Infinity Loop of My report

rbuser

Dear Jim,

I have tried the method you provided, but the problem is still exist, and
the problem seems that do not related to the printer setup.

I have placed a small SQL Server(2000) Database Backup file and a demo
project(Delphi 6) on web, they can simulate the inifinity loop problem.

DB file: http://raymondicy.uhome.net/DB.zip
Project: http://raymondicy.uhome.net/Project.zip

Best regards,
Raymond Ng
----------------------------------------------------------
Programmer
Orbitec Solution Limited
Tel: (852) 25755125
Fax: (852) 25752221
Email: raymond_ng@orbitec-solution.com

digitalmetaphors

Ok, I'll download and take a look. Are you using any service packs for SQL
Server that I'll have to install to restore from backup? We have SP 3 on cd,
but haven't installed any SP's at this time, fearing we need to test using
plain jane SQL Server 2000 for testing of our release builds.

Cheers,

Jim Bennett
Digital Metaphors

rbuser

Dear Jim,

I am using SQL Server 2000 SP3, thanks.

Best regards,
Raymond Ng
----------------------------------------------------------
Programmer
Orbitec Solution Limited
Tel: (852) 25755125
Fax: (852) 25752221
Email: raymond_ng@orbitec-solution.com

digitalmetaphors

The backup failed during the restore process. However, I looked at your form
and the problem is that you are parameterizing the queries and then also
setting the MasterFieldLinks and MasterDataPipeline properties on each
detail pipeline. Don't do this when you are already linking using Delphi
parameters:) That should fix the problem.

Cheers,

Jim Bennett
Digital Metaphors

rbuser

Dear Jim,

So strange! I have tested the Backup file, which is okay in SQL Server SP1 &
SP3.

I have removed all setting in MasterFieldLinks and MasterDataPipeline
properties (Actually, the setting in the MasterFieldLinks and
MasterDataPipeline are inserted by the system automatically during
designation). However, the problem is still exist.

Please help me to find out the problem, thank you very much.

Best regards,
Raymond Ng
----------------------------------------------------------
Programmer
Orbitec Solution Limited
Tel: (852) 25755125
Fax: (852) 25752221
Email: raymond_ng@orbitec-solution.com

digitalmetaphors

[quote](Actually, the setting in the MasterFieldLinks and MasterDataPipeline
are inserted by the system automatically during designation). [/quote]

What do you mean? When is does the designation event take place? I think the
setting of these properties is the cause of the problem.

RB relies on the Delphi linking in your case and therer isn't a known issue
like this. Can you take RB out of the equation and use DBGrids setup in a
master detail configuration? Do the detail grids show the correct detail
records when you click on a master grid? Is the data ordering shown
incorrectly in the grids?


Cheers,

Jim Bennett
Digital Metaphors

rbuser

Dear Jim,

[quote](Actually, the setting in the MasterFieldLinks and MasterDataPipeline
are inserted by the system automatically during designation). [/quote]
Sorry, since I never touch the MasterFieldLinks and MasterDataPipeline
properties, so I guess the setting in these properties are setup by the
system automatically. Anyway, the problem is still exist even the
MasterFieldLinks and MasterDataPipeline have no data.

Furthermore, one more surprise occur! After modified my demo project (linked
all data source to a grid), the loop problem does not happen. However, if I
remove the link with grid, the problem happens again! Please download the
demo project again (which is modified), it can show you how strange it is!

Demo project: http://raymondicy.uhome.net/Project.zip

Best regards,
Raymond Ng
----------------------------------------------------------
Programmer
Orbitec Solution Limited
Tel: (852) 25755125
Fax: (852) 25752221
Email: raymond_ng@orbitec-solution.com

digitalmetaphors

It still is not letting me restore from backup to recreate the database.
Could you send a SQL script to create and populate the database with some
data to show the error?


Cheers,

Jim Bennett
Digital Metaphors

rbuser

Dear Jim,

Please download the following Project and Database Script:
Project files: http://raymondicy.uhome.net/RBTest.zip
Table Script and Data :http://raymondicy.uhome.net/SQLTableAndData.zip

In the download file "SQLTableAndData.zip", you can find a SQL Script and an
Excel 97-2000 formated file, please execute the SQL script in a new Database
and import the data from the Excel file.

Thank you for your attention, look forward to hearing from you.

Best regards,
Raymond Ng
----------------------------------------------------------
Programmer
Orbitec Solution Limited
Tel: (852) 25755125
Fax: (852) 25752221
Email: raymond_ng@orbitec-solution.com

digitalmetaphors

I'll download it the new project and run it. Thankyou for your patience.


Cheers,

Jim Bennett
Digital Metaphors