Hi Paul ---
Could be a couple of things: If a private datasession, do you have SET DELETED ON in Form.DataEnvironment.BeforeOpenTables? SET DELETED scopes to datasessions....another thing could be your are requerying the view *before* commiting the deletion. You have to TABLEUPDATE the base table after a DELETE.
>
>I am working with a parameterized view for the first time..I'm realizing I should have used them sooner! Anyway I have a grid that is based on a view. I have a button where I can delete a record in the view. However the grid doesn't show that the record is deleted(by making it disappear) until I click on the grid. I have tried ...grdxyz.refresh(), but this didn't work...I also tried to requery the view and of course realized then the deleted record was brought back.
>
>It must be something simple..I'm sorry I can't determine what it is.
>
>Thanks,
>
>Paul
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05