« on: January 22, 2019, 07:27:07 pm »
I have this query:
cSQL := 'SELECT ' +
'ID, Scheidsrechter AS Referee, Scheids_ID, Divisie AS Division, ' +
'StrFTime("%d-%m-%Y",Datum) AS Date, ' +
'StrFTime("%H:%M",Tijd) AS Time, ' +
'[Team A], [Team B], Seizoen, Wed_ID, ' +
'TBL, Positie AS Position, Systeem AS System, DD ' +
'FROM qry_Overzicht_Evaluaties ' +
'WHERE ' +
'((Seizoen=:Sei_ID) OR :Sei_ID=0) ' +
'AND ' +
'((Scheids_ID=:Scheids_ID) OR :Scheids_ID=0) ' +
'ORDER BY Date DESC, Time DESC;';
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 »
Logged
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