Hi Kevin
I am not sure if this has been fixed, but since it 'bit me' really hard many years ago, I have learnt the hard way that you must assure that the index key always has a fixed number of characters or digits. So I suggest your index be STR(yourint,6) and NOT yourint.
>I have a database with 2 tables Assets.dbf, and Location.Dbf.
>
>Both tables have an
integer id column, assetid.
>
>In the DBF, there is a persistant relationship between the 2 on assetid.
>
>The table Location has a regular, ascending key on Assetid.
>
>When I SET ORDER TO AssetId, I then no longer see most of the 2000
>records in the table. I can still see 3 records, but the rest are not
>visible.
>
>SEEK and SQL SELECT fails. SET DELETED is OFF
>
>If I change the index to Descending, or remove the index, or change the
>field type to numeric, or remove the persistant relation, all the records
>in Location are then accessable.
>
>This behavior occures in VBP6-8
>
>Anyone know whats going on?