>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