Totaling Records without adding in deleted records? - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Totaling Records without adding in deleted records?

Message

From

08/06/1999 12:46:49

Mike Helland
MonadPad.com
Seattle, Washington, United States

To

08/06/1999 11:57:53

Colin Magee
Metroland
Mississauga, Ontario, Canada

General information

Forum:

Visual FoxPro

Category:

Databases,Tables, Views, Indexing and SQL syntax

Title:

Re: Totaling Records without adding in deleted records?

Miscellaneous

Thread ID:

00227450

Message ID:

00227511

Views:

21

>If SET DELETED is ON you don't even need the FOR !DELETED() part. COUNT respects the status of SET DELETED where RECCOUNT() does not.
>

Count also respects SET FILTER when reccount doesn't, comes in handy

Click here to load this message in the networking platform