----- Original Message -----

From: "White, Clark" <WhiteC@jsc.mil>

To: "Multiple recipients of ProFox" <profox@leafe.com>

Sent: Friday, September 13, 2002 4:21 PM

Subject: RE: VFP6: Rushmore/Network Performance

> Yeah, but "dropping indexes" is a tough decision when you have users who

are

> used to dynamically sorting records in a list by every header that

appears.

> I will definitely test removing the deleted() flag. According to the

> articles, this will kill my main query builder because it does the

> following:

>

> 1. Asks the user for the criteria

> 2. Counts the records that meet the entered criteria.

> 3. Display the criteria (if the user selects view results).

>

You can create indexes on the fly on a view result. User clicks on grid

column header. If theres' no index it's created, else it's activated with

SET ORDRER . DoubleClick it swaps between SET ORDER TO .. DESCENDING to

ASCENDING

-Anders