Conditional Index Question
Posted: Thu Mar 04, 2010 4:26 pm
This is DBFCDX
I have a conditional index like this:
Index on PadL(AllTrim(Str(BillID)),2,"0")+DTOS(SVCDate) TAG "PickBatch" TO CDXFile FOR DBFile->Approved .and. !DBFile->Assigned .and. !Empty(DBFile->BillID)
This index is then used to pick specific bill ID's from oldest date forward etc when creating batches.
My question is, if any of the fields that are referenced in the "For" conditions are updated, will this index update automatically?
In, use it seems to be skipping over records that match the criteria.
TIA,
Stu
I have a conditional index like this:
Index on PadL(AllTrim(Str(BillID)),2,"0")+DTOS(SVCDate) TAG "PickBatch" TO CDXFile FOR DBFile->Approved .and. !DBFile->Assigned .and. !Empty(DBFile->BillID)
This index is then used to pick specific bill ID's from oldest date forward etc when creating batches.
My question is, if any of the fields that are referenced in the "For" conditions are updated, will this index update automatically?
In, use it seems to be skipping over records that match the criteria.
TIA,
Stu