ORDER BY RecID DESC ??

[Ruslan Zasukhin]

On 3/23/05 12:56 PM, "Thomas Biedorf" <thomas at startmovie.net> wrote:

Hi Thomas,

In fact there is no sense sort on RecId.
ObjectPtr and RecID contain internal values.

You need sort on fields which contain some values.

> Hi,
> in Director I want to sort a table by RecID (look at subject)
> descending. Unfortunately Valentina doesn't find any entry.
> 
> SELECT RecID,* FROM table ORDER BY RecID DESC
> 
> doesn't find anything.  GetRecordCount() returns zero.
> 
> SELECT RecID,* FROM table ORDER BY somethingelse DESC
> 
> si working. How do I have to write the SQL-Statement? I didn't find
> anything about it in the Docs.

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