Please ignore this.

I found my error.

Thank you.
pfewww.

--- In IBObjects@y..., sveinpetter@h... 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