I have a table (named test) with a structure like this:

ObjectID n 6
ParentID n 6
Description c 20
...

ParentID refere to other ObjectID in the same table.

I want to select all ObjectID who have there Parent deleted to delete them to.

In my program i delete an item in the test table and, after that, i run this select:

SELECT test.ObjectID ;
FROM Test ;
WHERE test.ParentID IN ;
(SELECT Test.ObjectID FROM Test WHERE DELETED() = .T.);
INTO CURSOR ToDel

Nothing is returned!
What's wrong?