[FAQ] "ORDER BY RecID" crashes Valentina

[Ruslan Zasukhin]

on 1/26/03 3:53 AM, Elizabeth Robar at erobar at earthlink.net wrote:

Hi Elizabeth,
>
> I don't seem to be able to issue any SQL statement with an "ORDER BY
> RecID" clause -- every time I do, Valentina crashes (with crash logs
> jumping up all over the place -- both ViSQL and REALBasic).  Is this
> inherent to Valentina's indexing - do I need to create a Virtual Field
> based on the RecID?  Other SQL statements work fine, and according to
> the "Diagnose Report" from  Valentina Carbon, the database is fine.

I am not sure now, but it seems sort by RecID really crashes because it do
not have index. This bug must be fixed.

But you do not need sort by RecID, because Valentina self build result
sorted by RecID.

-- 
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://listserv.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------