Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Parent-child report problem. Wrong area is selected
Message
De
02/09/2005 03:18:17
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Titre:
Parent-child report problem. Wrong area is selected
Divers
Thread ID:
01046107
Message ID:
01046107
Vues:
65
Hello ,
I have a very big problem .
Two tables: parent and child: "invoice" and "invoicep" . I have a report which contains in the header data from parent table (invoice) and in the detail contains records from child table (invoicep) .
THE BIG PROBLEM is that sometimes, the report returns error that a variable from report detail is not found (ex: 'Variable "quantity" is not found' ). Quantity is from child table (invoicep) . And I established catching the error that the cursor is on the parent table at the moment the reports writes the detail.
I have to say that before the REPORT FORM command I selected the child table and in report header the fields' variables are specfifying the parent name, like "invoice.client" .
The code is like:
SELECT invoicep
REPORT FORM ...
So the detail should be on invoicep cursor when writing the report .
VERY IMPORTANT. I have to say that the _screen object has a timer, which action does some operations, including "SELECT invoice" command .
I think this could be a reason. BUT, if the code selects the right table, how could the area change between the two lines , even if the timer's action is executing. I think the timer doesn't execute during the report .
What other reason could be ? Or how can I do to be sure that area won't change during a report ?

Thanks a lot !
Mihai .
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform