Environment: Linux Mint 20.2, Laz 2.0.12, FPC 3.2.2, FB 3.0
Gentlefolk, I have the following SQL on an IBQuery. Works well, reads table and all records are accessible in the IBQuery for table EventData.
Select PROGRAM_ID, PROGRAM_EVENT From PROGRAMDATA
inner join EVENTDATA on
PROGRAMDATA.Program_ID = EventData.Event_NO
I wish to sort the records on EventData.Event_NO.
I have tried appending various versions of
order by EventData.EVENT_NO asc;
With NO success. Test ok in the SQL editor but records do not get sorted.
Any ides, suggestions appreciated, Ian.