Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Parent-child report problem. Wrong area is selected
Message
 
À
02/09/2005 03:18:17
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
01046107
Message ID:
01046110
Vues:
16
Mihai,
Try to stop the Timer BEFORE REPORT FORM command is issued and see if something changes. I never use two cursors for
reporting. I always prepare single cursor and based the report on it.



>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 .
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform