Hi All, I am writing an app using firebird and the IB components in delphi 6 professional.
I have a wierd problem. I have this query, (I have used an IBQuery and an IBDataset with the exact same results) I open the query - no problem. When try close the query I get an error message saying - "Dataset Open" The code is quite simply DM.Query.Open; and DM.Query.Close; This is the SQL Statement: select t.Facility_Number,t.supplier_number, s.name as supplier_Name, t.client_number,C.Name as client_name, sum(amount) from transaction_history T, suppliers S, Client C where (t.supplier_number = s.supplier_number) and (t.CLIENT_NUMBER = C.client_number) and T.transaction_Code <> 18 group by t.facility_number,t.supplier_number, s.name,t.client_number, C.Name having sum(amount) <> 0 Any help would be much appreciated. Regards Wayne
