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?
If we exchange an apple, we both get an apple.
But if we exchange an idea, we both get 2 ideas, cool...Gérald Santerre
Independant programmer - internet or intranet stuff - always looking for contracts big or small :)
http://www.siteintranet.qc.ca