>I am issuing:
> Delete for archive.ae_id = .b
>
>and my table is not deleting the data. I have set deleted on, I don't understand why it shouldn't delete. I even tried to delete through a view and it still didn't delete the record. Anyone have a clue?
>
>
>thanks
>nick patel

Nick,

A couple of things. First using the alis in the for clause opens the door to problems as the delete may not be processed in the same work area as the for condition addresses.

Try using one of these instead;

DELETE FOR Archive.ae_id = b IN Archive

 OR

SELECT Archive
DELETE FOR ae_id = b