Hi,
I think it has to do with you using a join in your where clause. I don't
think IBO appreciates it. Try an explicit join clause instead of an
implied one.

Randal Carpenter

On Tue, 31 Jul 2001 sveinpetter@... wrote:

> Hi all.
>
> I wonder if there is something wrong with this statement:
>
> Select * from TRANS, DETAIL where TRANS.TRANS_NR = Detail.TRANS_NR
> AND TRANS.PAY_MODE = 5 AND DETAIL.REC_ID > 0 AND TRANS.OP_MODE = 1
> AND TRANS.REC_ID = DETAIL.TRANS_REC_ID
>
> I put it through IBConsole, it takes about 2 seconds to show.
> I put this into an TIB_Query half an hour ago, and I'm still waiting
> for it to respond...
>
>
> Q := TIB_Query.Create(nil);
> Q.IB_Connection := DM1.IB_Connection1;
> Q.SQL.Add(Statement);
> Q.Open;
>
>
> Facts: TRANS table has 32.868 records, the detail table 39.271.
> Trans.REC_ID and Detail.REC_ID is unique. Trans.Trans_nr and
> Detail.Trans_nr is a part of the tables primary index.
>
> I am missing something obvious here...
>
> Best regards
> pfewww
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>