How can I count the total records in the grid? 1

[greenilo]

Dear Anybody,

Suppose after refreshing my grid from a filter command, it showed 6 records on the file, how can I put the no. 6 as the total count into my text box? (Same as counting the total records)?

Thank you.

 

[crewchiefpro6]

make a property called lnGridCount

In the method that refreshes the grid type in:

thisform.lnGridCount = reccount()

Or

in your select statement that creates the grid add this line:

thisform.lnGridCount = _tally




Don Higgins

http://www.crewchiefpro.com

 

[crewchiefpro6]

Whoops! I meant to say THE LINE AFTER the select statement


Don Higgins

http://www.crewchiefpro.com

 

[crewchiefpro6]

Here I go again, the preferred method after the select is actually this:

select blah blah blah

if _tally > 0
thisform.lnGridCount = _tally
endif


Don Higgins

http://www.crewchiefpro.com

 

[alvechurchdata]

Just out of interest, why haven't you got an Else clause to display a zero count?

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[ChrisRChamberlain]

greenilo

Beware deleted records - if you have

[COLOR=blue]SET DELETED ON[/color]

and you have any deleted records in the table/cursor the RECC() value will include deleted records.

[COLOR=blue]SET FILTER TO
COUNT FOR !DELETED() TO lnCount[/color]

lnCount will be the total unfiltered records available in the grid.

FAQ184-2483 - answering getting answered.​

Chris
PDFcommander^tm.net
PDFcommander^tm.com

 

[crewchiefpro6]

Geoff,
I left out the else because I was lazy at 2:00 am, yes it should have an else to inform the user that there are no records that match and to return.


Don Higgins

http://www.crewchiefpro.com

 

[greenilo]

Thank you very much Don. IT worked...

 

[alvechurchdata]

I left out the else because I was lazy at 2:00 am

Don't feel bad about it - I was fast asleep at 2:00 am.

Geoff Franklin

http://www.alvechurchdata.co.uk