|Subject||Re: [IBDI] Interbase 6.0 bug ?|
|Author||Fabrice Vendé - INFOCOB|
> Yes - a logic bug in your SQL. <g>?
> For the third query, tryBut the syntax in SqlRef.hlp is not in !
> Select * from ToDoList
> where (NOT (ToDoList.code in (select codefrom from ToDoListDone where
> codefrom is not null)));
And not in work fine with database like paradox.
> It's very inefficient! If you really NEED two tables, use joins andindexes.
>Because my ToDoListDone contains 40000 records (200 more each week !).
> I would suggest you need only one table, with a Boolean-style column
and ToDolist only 200 max!
And ToDoList is very used. But quicker with 200 records than 40000 !
SARL I N F O C O B
Developpement, formation, matériel, logiciel