Hi all,

I am trying to get a grid to sort on Resolutiondate, street name, street
number using the following Query. It will sort on resolution date, but the
secondary fields seem to have no effect. Is it possible, and if so, what am
I doing wrong.

Delphi 5; IBO 4.2Ha, Interbase 6.0, Windows XP Pro.

Thanks,
Marv

IBO_Query:

SELECT COMPLAINT.CPID // Primary Key//
, COMPLAINT.OPENDATE
, COMPLAINT.RESOLUTIONDATE
, COMPLAINT.RESOLVEDBY
, COMPLAINT.CSCLOSED
, (COMPLAINT.FirstNAME ||' '||COMPLAINT.LastNAME) as CustomerName
, COMPLAINT.ADDRESSNO
, COMPLAINT.PHONE
, ComplaintType.CTYPID
, ComplaintType.NAME
, EMPLOYEE.EID
, EMPLOYEE.LASTNAME
, EMPLOYEE.FIRSTNAME
, EMPLOYEE.MI as employeeMI
, STREETNAMES.SNAME
, STREETNAMES.SNAMESORT
FROM COMPLAINT
LEFT JOIN COMPLAINTTYPE on (ComplaintType.ctypid = complaint.complainttype)
LEFT OUTER JOIN EMPLOYEE on Employee.eid = Complaint.resolvedby
LEFT OUTER JOIN STREETNAMES on STREETNAMES.SID = Complaint.SID
Where complaint.water = :water
and complaint.csClosed = :csClosed
and complaint.ResolutionDate Between :StartDate and :EndDate

Ordering:

SNAME=STREETNAMES.SNAME, COMPLAINT.ADDRESSNO;
RESOLUTIONDATE=COMPLAINT.RESOLUTIONDATE, STREETNAMES.SNAME,
COMPLAINT.ADDRESSNO;

Ordering Links:

SNAME=ITEM=1
RESOLUTIONDATE=ITEM=2