I have a table with fields including a date field, a character field and a logical field that stores the deleted status of the record - .T. = current, .F. = Deleted.
id = N(10)
Char = Name C(30)
Date = Birth date D(8)
Active = L(1)
among other fields
When changes are made to a record a new record is created with the changes, Active = .T. and the active = .f. for the old record. Thus we have an audit trail of changes.
How do I create an index on the character field so as to SEEK only those that are active.
I use Locate for name = "MYNAME" and ACTIVE = .T. but this is too slow. I need SEEK so how do I create an index for this??
Set filter to ACTIVE = .T. is also too slow. There are > 250000 records (including the non active ones)
I need to
Set ORDER to TAG myindextag
and
SEEK "MYNAME" which will give me an active record.
Bernard