Is there some kind of 321 record limit on the grid section

[StevenH]

I'm experiencing something odd and not sure what's up.

I have a table of 2003 records but the grid section says there are only 321 records.

I thought I might have done something odd with the page or the section so I created a new page and added a new grid but that also shows the record count as 321.

In the console I typed Display Status which in VFP would show if a filter existed but nothing was listed. Dunno if this would work the same way in Lianja.

Any ideas what is going on?

[barrymavin]

Do you have a lot of deleted records? They will not be displayed.

if you do the following in the console what do you see?

use table name
count to m_count
? m_count

If the count is wrong then issue:

reindex

Check the section settings and make sure you have not saved the App with a search of filter active.

[josipradnik]

Barry made a typo:

use table name
count to m_count
? count

It should be, I suppose:

? m_count

And yes, I experienced this behaviour. I swear here was customers(115) and now is correct 90 as in grid.
This ? m_count showed 90.



I reindex and played with Optimize



This is something about refreshing. After playing with reindex and optimize I exited Lianja.
After come back this is ok.

Same problem is now with table employees (11) and grid and count say 9



select employees
count to m_count
? m_count

9

After optimize (and maybe reindex?) and refresh from same menu, it now shows 9.



Problem solved (for me).

[StevenH]

Sorry, dumbness on my part.

I'm accustomed to the Foxpro status bar which shows you the record you're on and the total number of records in the table.

What Lianja is showing is not the record count as in FoxPro but the "page" count. So, 321 "pages" in my app is made up of 2,003 records. And, although Lianja does have the label as "pages", my mind read it as "records".

So sorry about that.