Trouble with Order BY

[Jochen Kötter]

Hi Ivan,

this is the driven code:

   sql = "SELECT w.Wochentag, w.Uhrzeit, w.UhrzeitBis, u.Fach,  
s.Suchfeld, u.Zeitraum, w.UEmin, w.Turnus, s.RecID as SchID, u.RecID  
as UID, w.RecID as WID " +_
   "FROM	Wochenstunden w LEFT OUTER JOIN Unterricht u ON " +  
db.mblnkUnterichtWochenstunden.Name +_
   " INNER JOIN Schueler s ON " + db.mblnkSchuelerUnterricht.Name + "  
ORDER BY w.Wochentag, w.Uhrzeit"
   cs = db.SqlSelect( sql )

I get the Errornumber -39. I work with Realbasic an Valentina local.

If I reduce the ORDER BY - Clause to " ORDER BY w.Wochentag" all  
works fine.

Greetings
Jochen Koetter



Am 05.07.2007 um 09:55 schrieb Ivan Smahin:

> Hello Jochen,
>
> Thursday, July 5, 2007, 10:48:38 AM, you wrote:
>
>> Hi,
>
>> Valentina 3.1 doesn't want to ORDER BY VTimeField.
>> Is there anyone who can Confirm this?
>
> I  have tried it. It works fine. Could you describe what are you doing
> more detailed?
>
> Also please try
> 1. Diagnose database
> 2. Reindex
>
>
> -- 
> 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