Agreed. I wasn't really thinking in terms of SPT, but yes, that would make things way too dynamic for record number to be considered viable.

Alan

>Hi Alan
>
>I'm using SPT for all tables now, so RECNO() may always be a problem since the record may have been replaced by a query, since the recno() was remembered.
>
>>That makes sense. So for things like "Lookup" tables using record number should be ok, but for dynamic tables record number could cause major problems.
>>
>>Alan
>>
>>>Alan,
>>>
>>>>I agree with you that there is no perfect solution,
>>>but if the key is at all useable,
>>>I believe it is far better than using record number
>>>
>>>I agree with you, but with special cases;
>>>i use this schema:
>>>- at low level class,
>>>where i have full control and many tables are static ( only data model ) i use RECNO();
>>>- at business objects level i use a primary index key with a fixed schema.
>>>
>>>Fabio