[V4MD1.1] order by RecID DESC ?

[Ruslan Zasukhin]

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

Hi Hans,

> I have the following problem:
> 
> I tried this SQL statement
> 
> SELECT fld1 from tbl1 ORDER BY RecID DESC
> 
> but I get a syntax error.
> 
> My task is to give a list of all fld1 sorted by their creation's timestamp,
> i.e. the last added
> record has the greatest RecID.
> 
> Or is my thought wrong?
> 
> I get a void result without any error message.

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

-- 
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
-------------------------------------------------------------