SELECT COUNT(*)

[INFORMAT]

Hi,

Can you do something like
SELECT COUNT(*) FROM curEmployees

in VFP?

curEmployees is a simple VFP cursor

 

[mspratt]

SELECT * FROM curEmployees

? _TALLY

Regards,

Mike

 

[Mike Gagnon]

Yes, is there a problem when you tried it?

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[Mike Lewis]

Informat,

Can you do something like
SELECT COUNT(*) FROM curEmployees


You can do exactly that. The result will appear in a new cursor or browse window, with one row and one column.

But a much easier way would be:
? RECCOUNT("curEmployees")

(assuming curEmployees has no deleted records and there is no filter in force).

Mike


Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com

 

[INFORMAT]

Thanks,

everything works fine!

 

[ChrisRChamberlain]

assuming curEmployees has no deleted records and there is no filter in force

For further clarification, ? RECCOUNT("curEmployees") will return the same total irrespective of a filter being in force, and will be the total of all records including those marked as deleted.

FAQ184-2483 - answering getting answered.​

Chris
PDFcommander[sup]tm[/sup].com
PDFcommander[sup]tm[/sup].co.uk

 

[Mike Lewis]

Chris,

, ? RECCOUNT("curEmployees") will return the same total irrespective of a filter being in force, and will be the total of all records including those marked as deleted.


Yes, I agree. My point was that that might not match the number of records Informat was expecting to see. Presumably, if records were deleted or filtered out, he would expect those to be excluded from the count. (Or maybe not.)

Mike


Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com

 

[ChrisRChamberlain]

Mike

My point was that that might not match the number of records Informat was expecting to see.

That was the point I was also trying to make by the further explanation of your comments - should there be deleted records or a filter in force then RECC() would only be a solution for the total number of records.

Presumably, if records were deleted or filtered out, he would expect those to be excluded from the count. (Or maybe not.)

Good question - perhaps Informat could advise whether he or she is seeking available records or total records?

FAQ184-2483 - answering getting answered.​

Chris
PDFcommander[sup]tm[/sup].com
PDFcommander[sup]tm[/sup].co.uk

 

[INFORMAT]

I am seeking for available records

Thanks for the answers!

 

[HarryB]

You can use:

SELECT COUNT(*) FROM cursorname INTO ARRAY laCnt

You'll get the number of active, (not deleted), records in the array.