>>Just for curiosity, what happens if you put all your table/field names /

parameters to

>>UPPERCASE? It could be that in some part IBO fails in doing

Complaint.ComplaintType =

>>:COMPLAINTTYPE...

Marco

I tried this and it works! Good call.

Marv

SELECT COMPLAINT.OPENDATE
, COMPLAINT.RESOLUTIONDATE
, COMPLAINT.RESOLVEDBY
, COMPLAINT.CSCLOSED
, (COMPLAINT.FIRSTNAME ||' '||COMPLAINT.LASTNAME) as CustomerName
, COMPLAINT.ADDRESSNO
, STREETNAMES.SNAME
, COMPLAINT.PHONE
, COMPLAINT.COMPLAINTTYPE
, COMPLAINTTYPE.CTYPID
, COMPLAINTTYPE.NAME
, EMPLOYEE.EID
, EMPLOYEE.LASTNAME
, EMPLOYEE.FIRSTNAME
, EMPLOYEE.MI
, STREETNAMES.SNAME
, STREETNAMES.SNAMESORT
, COMPLAINT.CPID
FROM COMPLAINT
Left Outer 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.COMPLAINTTYPE = :complainttype
and COMPLAINT.RESOLUTIONDATE Between :startDate and :enddate

-----Original Message-----
From: mmenaz [mailto:mmenaz@...]
Sent: Monday, May 06, 2002 4:54 AM
To: IBObjects@yahoogroups.com
Subject: [IBO] Re: Sorting Problems


Just for curiosity, what happens if you put all your table/field names /
parameters to UPPERCASE? It could be that in some part IBO fails in doing
Complaint.ComplaintType = :COMPLAINTTYPE...
Just a supposition...
Thanks
Marco