I am trying to delete a record using a view. When I issue following command:

Select * from employee where employee.e_id = .d into array a__gen6
...
insert into ... from array a__gen6 ...
....
....
delete for lv_employee.e_id = .d
r3 = tableupdate(.t., .t., 'lv_employee')

the tableupdate variable r3 = .T. but the record still stays there. The base table (employee) is not in my dataenvironment just the view. Can doing select statement on base table (employee) prior to issuing delete on view cause this problem? I'm I missing something here?

Thanks
Nick Patel