Don't forget the WHERE clause....this is a count for specific
criteria...not a total record count for the table!
I would wager you're onto something though: I bet COUNT FOR locks the
header and SELECT COUNT(*) does NOT.
?????
On 10/22/2020 3:27 PM, Richard Kaye wrote:
Leaving aside the environment stuff like SET EXCLUSIVE and SET MULTILOCKS, my
first guess is COUNT FOR actually moves the record pointer through every row
in the table, Whereas SELECT COUNT() is reading the header.
--
rk
-----Original Message-----
From: ProfoxTech <profoxtech-boun...@leafe.com> On Behalf Of MB Software
Solutions, LLC
Sent: Thursday, October 22, 2020 3:24 PM
To: profoxt...@leafe.com
Subject: COUNT FOR hangs on record locking, but SQL - SELECT COUNT(*) works
with no issue. Why?
VFP9SP3
Why would a COUNT FOR hang ("Attempting to lock") whereas my easy workaround is SELECT
COUNT(*) FROM SomeCursor WHERE <<yada yada yada>> ??
tia,
--Mike
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message:
https://leafe.com/archives/byMID/b139eb93-a3f7-486a-e3df-a886f949c...@mbsoftwaresolutions.com
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.