Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Number of records in a grid
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00575563
Message ID:
00575795
Views:
25
>In the form that the class is positioned, there is a relation ship created from parent table to child table. As a record in the parent table is selected, the corresponding related records are available for the grid based on the child table. Since the table is buffered (5), the action on the form can Add or delete records to the Child table. These are not committed until a later stage. However, the forms action will depend on the remaining records that show up on the Grid. So when I try to look back and count records etc in the Child Table I am only getting the original records before the Adding and Deleting action occurs. If I do a Tableupdate, life is wonderful, however, I am looking at a means of being able to report back to the form the resulting number of records and let the form do the commitments as far as tableupdates etc. If I could get the count from the buffered area would be great. But everything I try gets back to the original.

Ronald,
How are you looking back? If you select the work area and use commands like SCAN/ENDSCAN, COUNT, SUM, etc. then you should get the buffered data.

If you use SQL statements then you won't because it uses the underlying table opened in a new workarea and this wouldn't have the new changes. This is also true if you open the alias again under a new alias manually.
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform