>>No index set. I even tried it on a table that has no index's defined, ie no cdx file at all. Oh well.... nothing really important.
>
>Run this:
>
>
create table inserttest (f1 n)
>for lnI = 1 to 20
> append blank
> replace f1 with lnI
>endfor
>go 5
>insert blank
>replace f1 with 21
>browse
>
>You should see
>
>1
>2
>3
>4
>5
>21
>6
>...
Seems to work only if there are no indexes at all.
Try add index and set order to before inserting...
If it's not broken, fix it until it is.
My Blog