about filtering

[lucasdebeltran]

Hi,

I have a DBF with 2 fields, FSERIE and FNUBER

I have those records:

A 2
A 6

B 1
B 2
B 3

D 1
D 2


I need to filter from B 2 to D 1 so I will have:

B 2
B 3
D 1


But does not work:

Code: Select all  Expand view

cCondicion := "(FIELD->FSERIE >= " +CHR(34)+cFSERIE1+CHR(34)+ ".AND. FIELD->FNUMBER >= " + AllTrim( Str( nNumb1 ) ) + " ) .AND. " + ;
                 "(FIELD->FSERIE <= " +CHR(34)+cFSERIE2+CHR(34)+ " .AND. FIELD->FNUMBER <= " + AllTrim( Str( nNumb2 ) )+")"
 

Please, any clue will be apreciated.

Thanks

[Gale FORd]

The logic is not correct and I cannot tell if there is a space between fields. Assuming there are no spaces and 2nd field has a fixed length of 1, then try this

Code: Select all  Expand view

cCondicion := [FIELD->FSERIE+FIELD->FNUMBER >= "]+cFSERIE1+AllTrim( Str( nNumb1 ) ) +
   [" .AND. FIELD->FSERIE+FIELD->FNUMBER <= "]+cFSERIE2+AllTrim( Str( nNumb2 ) )+["]
 

[lucasdebeltran]

Gale,

Thanks very much for reply.

It does not work fine:

Code: Select all  Expand view

cFSERIE1 := "A"
 nCodigo1 := 24

 cFSERIE2 := "D"
 nCodigo2 := 1




cCondicion := [alltrim(FIELD->FSERIE) + alltrim( str(FIELD->FNUMERO) ) >= "]+cFSERIE1+AllTrim( Str( nCodigo1 ) ) +;
   [" .AND. alltrim(FIELD->FSERIE) + alltrim( str(FIELD->FNUMERO) ) <= "]+cFSERIE2+AllTrim( Str( nCodigo2 ) )+["]
 

I got:
A3
A4
A5
A6
A7
A8
A9

A24
A25
B1
the rest is fine.

But I don´t know why I get A3, A4, etc that are not on the range I need.

[Marc Vanzegbroeck]

Hi,

Why you use an index + scope

Code: Select all  Expand view

cFSERIE1 := "A"
nCodigo1 := 24

cFSERIE2 := "D"
nCodigo2 := 1
INDEX ON UPPER(FSERIE)+STR(FNUMERO,2,0)
SET SCOPETOP TO UPPER(cFSERIE1)+STR(nCodigo1,2,0)
SET SCOPEBOTTOM TO UPPER(cFSERIE2)+STR(nCodigo2,2,0)

Regards,
Marc

[lucasdebeltran]

Marc,

Thank you.

I also tried Scopes at first with no luck.

But with help at the spanish forum I discovered that as my field FSERIE has tree characters long, Scope should be A 000000000000020 instead of A000000000.

[Marc Vanzegbroeck]

Indeed,

In my example I assumed that FSERIE was 1 character long and FNUMERO a nummeric-field of 2 long.

Regards,
Marc

[lucasdebeltran]

Yes yes, thank you.

The fault was mine