--- In [email protected], "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, It must be pretty old Firebird to accept that syntax SQL is a lot neater and FB uses it better. I've not use IB components and I seem to recall that they would fubar with Firebird after a certain FB version. Try running your code in one of the developer tools that come with FB or else simplify your query to the point where it is the least complex but still fails.
I use Fib+ where transactions are managed directly. Not much help I'm sorry Mick
