It seems I cannot do an ORDER BY on a REALSQLDatabase. Am I correct?
Would be an extraordinarily PITA if I'm right.
--
Thom McGrath
The ZAZ Studios
<http://www.thezaz.com/> AIM: thezazstudios
It works for me. I use it in many instances. I.e. I have
dim rs as Recordset = db.SQLselect("SELECT * FROM mytbl ORDER BY fld1;")
(typed from memory)
I have checked that with the SQLite Browser. Looking at the records
there, they are completely out of order. In the application using the
above, they are in order in the Recordset.
--
Cheers,
Peter
TI PowerBook G4, 1GHz, 1GB RAM, OSX 10.3.9, RB2006r1 Pro
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
