[V4MD1.1] order by RecID DESC ?

[Ruslan Zasukhin]

On 1/28/05 4:27 PM, "Hans-Joerg Bibiko" <bibiko at eva.mpg.de> wrote:

> Ruslan Zasukhin wrote:
> 
>>> SELECT fld1 from tbl1 ORDER BY RecID DESC
>>> 
>> 
>> 1.x do not allow sort on RecID.
>> 
>> What sense in this?
>>     SELECT fld1 from tbl1 ORDER BY RecID DESC
>> 
>> If you very need this, you can create BaseObject Method = RecID.
>> And use it in the ORDER BY
>> 
> 
> Of course! Thanks you.
> 
> The sense of it is very easy. I need a very easy way to sort my records by
> creation time without
> creating a new field, by the principle last-in first-out.

RecID cannot be used for this safely!

If you delete a record, and add new one then RecId will be reused.

You can use this way, ONLY and ONLY If you do not delete records


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------