Recent

Author Topic: [Solved] Query won't sort  (Read 1421 times)

madref

  • Hero Member
  • *****
  • Posts: 949
  • ..... A day not Laughed is a day wasted !!
    • Nursing With Humour
[Solved] Query won't sort
« on: January 22, 2019, 07:27:07 pm »
I have this query:
Code: Pascal  [Select][+][-]
  1.   cSQL := 'SELECT ' +
  2.           'ID, Scheidsrechter AS Referee, Scheids_ID, Divisie AS Division, ' +
  3.           'StrFTime("%d-%m-%Y",Datum) AS Date, ' +
  4.           'StrFTime("%H:%M",Tijd) AS Time, ' +
  5.           '[Team A], [Team B], Seizoen, Wed_ID, ' +
  6.           'TBL, Positie AS Position, Systeem AS System, DD ' +
  7.           'FROM qry_Overzicht_Evaluaties ' +
  8.           'WHERE ' +
  9.           '((Seizoen=:Sei_ID) OR :Sei_ID=0) ' +
  10.           'AND ' +
  11.           '((Scheids_ID=:Scheids_ID) OR :Scheids_ID=0) ' +
  12.           'ORDER BY Date DESC, Time DESC;';
  13.  
When both Sei_ID AND Scheids_ID are 0 (Zero) the query won't sort on Date and Time
Does any1 know why?
« Last Edit: January 23, 2019, 07:24:56 am by madref »
You treat a disease, you win, you lose.
You treat a person and I guarantee you, you win, no matter the outcome.

Lazarus 3.99 (rev main_3_99-649-ge13451a5ab) FPC 3.3.1 x86_64-darwin-cocoa
Mac OS X Monterey

madref

  • Hero Member
  • *****
  • Posts: 949
  • ..... A day not Laughed is a day wasted !!
    • Nursing With Humour
Re: Query won't sort
« Reply #1 on: January 23, 2019, 07:24:39 am »
Found my own answer
It should be

Code: Pascal  [Select][+][-]
  1. 'ORDER BY Datum DESC, Tijd DESC;';
You treat a disease, you win, you lose.
You treat a person and I guarantee you, you win, no matter the outcome.

Lazarus 3.99 (rev main_3_99-649-ge13451a5ab) FPC 3.3.1 x86_64-darwin-cocoa
Mac OS X Monterey

 

TinyPortal © 2005-2018