Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Parent-child report problem. Wrong area is selected
Message
From
02/09/2005 03:18:17
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Parent-child report problem. Wrong area is selected
Miscellaneous
Thread ID:
01046107
Message ID:
01046107
Views:
66
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 .
Next
Reply
Map
View

Click here to load this message in the networking platform