Hi Nick,
Try BROWSE FOR archive.ae_id = .b
Does that find the record?
Is B a property in a "WITH This" construct?
I always do DELETE FOR archive.ae_id = .b IN Archive whick ensures I'm in the right work area without switching.
I NEVER use TRIM in string matching situations. If b is blank, instead of deleting the blank ones, it would deleted 'em ALL. (Assuming EXACT is OFF, which is the default.) If you wish to delete all "Smith ", and TRIM, you also delete all "Smithsons". Ensure that b is the same length as AE_ID.
>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
Charlie