SQL sort question

[william humphrey]

I was thinking. I have two mac os laptops. One of them has the latest beta
of vServer and I did some work on the database on that system and then
copied it back here so maybe that affected it.

Diagnose says database OK. I just re-indexed the database and that solved
the problem. thanks for the suggestion.


On Tue, Feb 26, 2013 at 2:39 PM, Ivan Smahin
<ivan_smahin at paradigmasoft.com>wrote:

>
> On Feb 26, 2013, at 5:42 PM, william humphrey <bill at bluewatermaritime.com>
> wrote:
>
> I have been using "ORDER BY" to sort a field which has dates in the format
> yyyy-mm-dd for years now and just today it sorts it like this (with "ORDER
> BY DESC):
>
> 2006-02-15
> 2005-03-15
> 2013-01-24
> 2012-05-17
> 2012-05-10
>
> What is going on?
>
> I tested other sorts including recID and they work. Also that weird sort
> is not dependent on recID
>
> The above should have sorted:
>
> 2013-01-24
> 2012-05-17
> 2012-05-10
> 2006-02-15
> 2005-03-15
>
>
> What about database diagnose and reindex in case of problems?
>
> --
> Best regards,
> Ivan Smahin
> Senior Software Engineer
> Paradigma Software, Inc
> Valentina - The Ultra-Fast Database
> http://www.valentina-db.com
>
> --
> Best regards,
> Ivan Smahin
> Senior Software Engineer
> Paradigma Software, Inc
> Valentina - The Ultra-Fast Database
> http://www.valentina-db.com
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>
>


-- 
http://www.bluewatermaritime.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20130226/5beb32a6/attachment.html>