Hi all
assume You have a database with fields NAME, DATE.
Is it at all possible to sort the database that one field (NAME) is ascending and other field (DATE) is descending? Like this:
A 9
A 8
A 6
B 7
B 3
B 1
C 5
C 1
Note that NAME may me long and have many different characters
?
Simple order I use is NAME+DTOS(DATE) but then DATE is same direction (A/D) as NAME.
On Friday, January 8, 2021 at 8:56:14 AM UTC-7, ramo***@gmail.com wrote:Hello David
Hi allDo you have the descend() function that was in Clipper? https://www.itlnet.net/programming/program/Reference/c53g01c/ng369b2.html
assume You have a database with fields NAME, DATE.
Is it at all possible to sort the database that one field (NAME) is ascending and other field (DATE) is descending? Like this:
A 9
A 8
A 6
B 7
B 3
B 1
C 5
C 1
Note that NAME may me long and have many different characters
?
Simple order I use is NAME+DTOS(DATE) but then DATE is same direction (A/D) as NAME.
If so NAME+DESCEND(DTOS(DATE)) should work. Might be problematic on an SQL-like server.
David A. Smith
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 286 |
Nodes: | 16 (2 / 14) |
Uptime: | 84:22:54 |
Calls: | 6,495 |
Calls today: | 6 |
Files: | 12,097 |
Messages: | 5,276,895 |