> Yes - a logic bug in your SQL. <g>

?

> For the third query, try
> Select * from ToDoList
> where (NOT (ToDoList.code in (select codefrom from ToDoListDone where
> codefrom is not null)));

But the syntax in SqlRef.hlp is not in !
And not in work fine with database like paradox.

> It's very inefficient! If you really NEED two tables, use joins and

indexes.

>
> I would suggest you need only one table, with a Boolean-style column
> "Done"....?

Because my ToDoListDone contains 40000 records (200 more each week !).
and ToDolist only 200 max!
And ToDoList is very used. But quicker with 200 records than 40000 !

Thank you.

Fabrice Vende
fabrice@...

-
SARL I N F O C O B
Developpement, formation, matériel, logiciel
http://www.infocob.com