Trouble with Order BY

[Jochen Kötter]

Hello Ivan,

I did some tests with my Database and Vstudio. The ORDER BY works  
there with the time Field.
I must search on another place, whre the error comes from. It' hard  
to be a noobie ;-)

Have a nice day.

Greetings
Jochen Kötter


Am 05.07.2007 um 10:12 schrieb Ivan Smahin:

> Hello Jochen,
>
> Thursday, July 5, 2007, 11:01:36 AM, you wrote:
>
> JK> Hi Ivan,
>
> JK> this is the driven code:
>
> JK>    sql = "SELECT w.Wochentag, w.Uhrzeit, w.UhrzeitBis, u.Fach,
> JK> s.Suchfeld, u.Zeitraum, w.UEmin, w.Turnus, s.RecID as SchID,  
> u.RecID
> JK> as UID, w.RecID as WID " +_
> JK>    "FROM        Wochenstunden w LEFT OUTER JOIN Unterricht u ON  
> " +
> JK> db.mblnkUnterichtWochenstunden.Name +_
> JK>    " INNER JOIN Schueler s ON " +  
> db.mblnkSchuelerUnterricht.Name + "
> JK> ORDER BY w.Wochentag, w.Uhrzeit"
> JK>    cs = db.SqlSelect( sql )
>
> JK> I get the Errornumber -39. I work with Realbasic an Valentina  
> local.
>
> JK> If I reduce the ORDER BY - Clause to " ORDER BY w.Wochentag" all
> JK> works fine.
>
> Could you send me some database for testing?
>
> -- 
> 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