Trouble with Order BY

[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