Hello All
I have a IBOquery like this.

SELECT COUNT(Check_detail.CK_ID) Ck_id
FROM CHECK_DETAIL Check_detail
LEFT OUTER JOIN CHECK_MASTER Check_master
ON Check_detail.CK_ID = Check_master.CK_ID
WHERE (((Check_detail.CK_EMP_KEY = '003')
AND (Check_detail.CD_RECORD_CODE = '4')
AND (Check_detail.CK_RECORD_TOTAL_TYPE = 'C')
AND (Check_master.CK_CK_DATE BETWEEN '02/01/2001'
AND '02/28/2001')))


What happens if I attach code to a button to open the query I get
results. But if the query runs in a procedure that many other querys
run then there are no results. It is as if it is not waiting to
finish the query. If I attach code to a button to refresh the query
after the procedure runs the data shows up. There are a lot of other
querys and they all work fine. It seems that this perticular SQL
syntax has a problem. I am using latest IBO update.


Thanks
Bo Ugljesic
Lou-Ray Associates