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