David,
You need to specify the word DESC for each column, so ...
ORDER BY dserv, starttime DESC
should become
ORDER BY dserv DESC, starttime DESC
---------------------------------------------------------------------------
Eric M. Bienstock, Ph.D.
Database Development, etc.
Authorized R:BASE Developer
Eric M. Bienstock & Associates, Inc.
day: 212-978-7948 eve: 973-763-8650(8)
FAX: 209-882-9250 [EMAIL PROTECTED]
http://members.home.net/ericmb/Ericmb.htm
---------------------------------------------------------------------------
----- Original Message -----
From: "David Ebert" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 10, 2001 10:13 AM
Subject: CHOOSE sort problem
| I'm trying to sort the output of a CHOOSE in descending order. If I
specify
| the field names from the table it sorts ascending, if I use the column
| numbers in the table I get a bad ORDER BY error, and the same if I specify
| the number of occurance in the CHOOSE (as if for a SELECT).
|
| The original CHOOSE: (advance apologies: my mail client doesn't like to
| display the following as plain text).
| --Select Outreach record for staff productivity
| CHOOSE vtgoid FROM #VALUES +
| FOR ((CTXT(dserv)) + ' ' + (CTXT(zipcode)) + ' ' + (CTXT(starttime)) ++
| ' to ' + (CTXT(endtime)) + ' ' + (CTXT(MALES + FEMALES))), goid FROM
genout
| +
| ORDER BY dserv, starttime DESC +
| AT 20 CENTER TITLE 'Outreach Incidents' +
| CAPTION 'Select one incident' LINES 12
|
