Wayne <[EMAIL PROTECTED]> wrote: 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
hi wayne
but i think you have linked somehow the IBquery to the IBdataset
---------------------------------
Boardwalk for $500? In 2007? Ha!
Play Monopoly Here and Now (it's updated for today's economy) at Yahoo! Games.
