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:
00575820
Views:
27
>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.

I was using a SQL because the orginial table has hundreds of thousands of records and typically there is only 3 or 4 records related to the parent table. I find that using anytype of SCAN/ENDSCAN is very time consuming. I was just hoping there was some method or way to identify the small number of records in my grid (ususally 6 or less) I was hoping to find a way to go top, go bottom in grid and somehow determine the numer of rows, but unable to determine the number of rows in grid!! I was trying to get count of records with RECNO() less then 0 but this is very timeconsuming as well.

Thanks for your suggestions, but it looks like the tableupdate option will be more favorable being controlled from the class than the form.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform