OK, try to disconnect from any data-source (set data-source to NIL) and try again. The same message? Sometimes the data-aware components must close connections (especially the in the design state) but for some reason they can not do it properly. Try to isolate the error area, too: remove successively tables from the query and try again. Take a look at the trigger and event handles, try so remove the handles, too. It's here anything not usual?
Yes, that is too generic but for non-standard situation, you known. Maybe it can serves as some suggestion. Viet Anh On Fri, 18 May 2007 13:24:54 +0700, Wayne <[EMAIL PROTECTED]> wrote: > Hi Vo, > > All the tables are linked to the transaction_history table. Each one > of them has a foreign key in the transaction history. The other > tables are not linked to each other. I tried an IBQuery first then > the IBDataset, both have the same problem. I am totally confused. > > Thanks > > > Wayne > > > > --- In advanced_delphi@yahoogroups.com, "Vo Viet Anh" > <[EMAIL PROTECTED]> wrote: >> >> It's really weird! Can you provide more information of the > table >> relationship and how things are connected to each others? Without > more >> information it's impossible to tell why a standard behavior can > not >> establish. >> >> Viet Anh >> >> On Thu, 17 May 2007 22:26:18 +0700, aloui hichem > <[EMAIL PROTECTED]> >> wrote: >> >> > >> > >> > 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. >> >> >> >> -- >> Using Opera's revolutionary e-mail client: > http://www.opera.com/mail/ >> > > -- Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
