In general, you should never rely on the record number, but of course there may be cases where it's more convenient.

>hi,
>thank you for reply,
>thanks for explaine,
>i need to do this just for Special case at small table,
>
>m.qasem
>>Mohammed,
>>
>>you must learn that you can NOT insert records in the middle of the table, the new record will ALWAYS end up as the last record, and you shall also be happy for that! If you need the new record at a particluar place, you use an index for that!
>>
>>In the old dbase days, there was a command for inserting records in the middle of the table, but this command luckily was not duplicated in Fox. In the background this command created a set of new tables which were merged and renamed to the name of the original table afterwards. This ment that this command did not work in a multiuser environment, and could be EXTREMELY slow.
>>
>>>hi,
>>>thank you for reply,
>>>but, i see at ut somthing as
>>>insert at recono()....
>>>this what i need to small table.
>>>any idea.
>>>>>hi all,
>>>>> i need to insert new record between records at mytable.
>>>>>any help
>>>>>thanks.
>>>>
>>>>Use an index to control the logical record position. The record will be appended at the end of the table, but the index will make it appear at a position which depends on the index expression.
>>>>
>>>>Note: The INSERT command can be used to do what you are asking for, but: (1) This only works if the table has no indices, and (2) This is not good practice, since for a large table, the process will be very slow.