topic-26103

Posts: 368

Joined: Sun May 31, 2009 06:25 PM

FOR CLAUSE IN INDEX
Posted: Tue Apr 16, 2013 11:53 AM

Is this a valid for clause?

FOR ( ( ( empty( RECE ) .AND. empty( OBSE ) ) .OR. empty( DDIG ) ) .AND. !DELETED() )

I´ve re-created the index but I still see the record in browse even if the 3 fields are not empty.

Regards,

André Dutheil

FWH 13.04 + HB 3.2 + MSVS 10

Posts: 4840

Joined: Fri Nov 18, 2005 04:52 PM

Re: FOR CLAUSE IN INDEX
Posted: Tue Apr 16, 2013 12:15 PM

If you only want to see records that have all three fields empty then you need to change the .OR. to .AND.

If that is not what you want, then please explain.

Regards,
James

FWH 18.05/xHarbour 1.2.3/BCC7/Windows 10

Posts: 368

Joined: Sun May 31, 2009 06:25 PM

Re: FOR CLAUSE IN INDEX
Posted: Tue Apr 16, 2013 12:47 PM

I don´t know how it happened but I had duplicated fields in the DBF. I created a new DBF appended from the buggy one and now everything Works fine.

Thanks.

Regards,

André Dutheil

FWH 13.04 + HB 3.2 + MSVS 10

FiveTech Support Forums