xsharp.eu

Posted: **Fri Aug 14, 2020 5:41 pm**

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

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

Posted: **Fri Aug 14, 2020 6:27 pm**

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.

Posted: **Fri Aug 14, 2020 8:37 pm**

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

Posted: **Fri Aug 14, 2020 11:28 pm**

Hi Loy,

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

xsharp.eu

SEEK command on Integer type index tag

SEEK command on Integer type index tag

SEEK command on Integer type index tag

SEEK command on Integer type index tag

SEEK command on Integer type index tag