SEEK command on Integer type index tag

[Loy2888]

I searched this forum regarding this issue but it looks like no one has this issue reported yet.

Code: Select all

RddSetDefault("DBFVFP")

USE "TEMP.DBF" 
// This table is indexed on SERIES which is an integer. --> INDEX ON SERIES TAG SERIES

SET ORDER TO "SERIES"
SEEK 123      && ---> Throws an Error
SEEK "123"    && ---> Does not throw an error, but found() = .F.
LOCATE FOR SERIES = 123  && ---> Ok

[Chris]

Hi Loy,

I wrote a small test and it seems to work fine here. Can you please post the dbf and index file? There could be something special about it causing the order to fail.

[Loy2888]

Hi Chris,
See attached screenshot and a sample Temp.dbf file

[Chris]

Hi Loy,

Thanks, indeed this shows the problem! Will log it for Robert to look into it.