Subject RE: To SET [IBO] Slow query question
Author Nico Callewaert
Hi Set,

One more question. I only tested this code below in IBConsole.
It is working well. If I paste this code in a TIB_Query component, I have
a error message 'Fieldname : not found'. I'm already looking 2 hours at
it, but couldn't solve it maybe you know something.
Even this little piece of code is not working in a IB_Query, removing the A.
in fornt of the fielnames doesn't help

SELECT A.DealerNo, A.Country,
(SELECT B.Name FROM Country B WHERE B.Code = A.Country)
FROM Dealer A
WHERE A.DealerNo = 123456


Thanks again,

Nico Callewaert
-----Oorspronkelijk bericht-----
Van: Svein Erling Tysvar [mailto:svein.erling.tysvaer@...]
Verzonden: dinsdag 3 april 2001 13:37
Aan: IBObjects@yahoogroups.com
Onderwerp: Re: [IBO] Slow query question


Nico,
use a TIB_MonitorDialog to find out exactly what is taking so long. It
doesn't sound like a problem with your query since it is fast
interactively. But, does it help if you change to using subselects (a shot
in the dark, your MonitorDialog will help infinitely in making a proper
diagnosis)?

SELECT DealerNo, Name, Contact, Alfa, Title, Address1, Address2, Zip,
City,
Phone, Fax, E_Mail, Website, Comment, Vat, Country_EG, Reduction,
BankAccount, Foreign_BankCode, Foreign_BankName, Foreign_BankCity,
Foreign_BankSwift, General_Acc, Coin,
(SELECT B.Name FROM Country B WHERE B.Code = A.Country),
(SELECT C.Province FROM State_Prov C WHERE C.Code = A.State_Prov),
(SELECT D.Descr FROM [Nico Callewaert] Coin D WHERE D.Code =
A.Coin),
(SELECT E.Descr_1 FROM Deliv_Cond E WHERE E.Code = A.Deliv_Cond),
(SELECT F.Descr_1 FROM Payment_Cond F WHERE F.Code =
A.Payment_Cond),
(SELECT G.Language_Descr FROM Language G WHERE G.Language =
A.Language)
FROM Dealer A
WHERE DealerNo = :qDealerNo

Is it still as slow? Does your program use events?

Set

Yahoo! Groups Sponsor

Click Here to Find Software Faster


Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]