Conditional Index Question

This forum is for general support of Xbase++
Post Reply
Message
Author
Stuart.Fraser
Posts: 17
Joined: Thu Jan 28, 2010 10:07 am
Location: Victoria, BC Canada
Contact:

Conditional Index Question

#1 Post by Stuart.Fraser »

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

Stuart.Fraser
Posts: 17
Joined: Thu Jan 28, 2010 10:07 am
Location: Victoria, BC Canada
Contact:

Re: Conditional Index Question

#2 Post by Stuart.Fraser »

Never mind... I figured it out.

Stu

Post Reply