New topic: Order by, can it allows 2 fields?
<http://forums.realsoftware.com/viewtopic.php?t=29687> Page 1 of 1 [ 2 posts ] Previous topic | Next topic Author Message Anna Post subject: Order by, can it allows 2 fields?Posted: Sat Aug 22, 2009 8:27 am Joined: Tue Dec 11, 2007 8:03 pm Posts: 17 There is a command in database query - order by. Order by usually followed by the field to order. I wonder if anybody has ever do order for 2 fields e.g. date and time in a single recordset query? _________________ Learn animation & design ===== Free Job & Career Guide Top jefftullin Post subject: Re: Order by, can it allows 2 fields?Posted: Sat Aug 22, 2009 8:54 am Joined: Wed Nov 15, 2006 3:50 pm Posts: 692 Yes: Example.. select... Order by Surname asc, forename desc select ... Order by name,rank,serialno (defaults to ascending order) Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 2 posts ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
