dw delete record problem
Posted on 2004-10-30
I am working on one project in PB 9.0 and I am getting one problem in deleting records in a DW.
I am retrieving data in a DW based on the search criteria. I am also adding and deleting records in the DW. I don't want to let the user modify the previously retrieved records in the DW. User can only modify newly added records. So i have set the protect property for one editable column to false/true using expression. It is working fine while adding records but in case of delete it is not working.
After inserting new record to the DW control moves to the editable column in the new row. If i give valid data it accepts it and again set focus to the same column and row. And hence i am not able to delete other records in the DW. If i try selecting other rows it does not moves the focus to that row. Even I click anywhere in the window it not moving focus out of the editable column and hence i can not select another row that i want to delete. The row status is set to NewModified. The code for searching and populating data in other columns for the newly added code is written in itemchanged event. the event returns 2 when successful.
Please tell how I can handle this problem. What code/property setting i have to write so that i can delete other records after adding new records. I tried lots of options the whole day but coulden't get rid of this problem.
Please reply ASAP. It is very very urgent for me. Please reply at the earliest.