Hi Mark,

Not completely sure I understand exactly what you're trying to accomplish.

If you're trying to just not have deleted records show up in the original cursor/view, you can include

WHERE NOT DELETED("MyTableName")

in the cursor/view definition (assuming you're looking at VFP data, of course). If you're doing that, it usually helps to have an index tag on DELETED() for the table(s) in question.

OTOH, if you're trying to permanently delete records that currently exist in a view, you would probably need to TABLEUPDATE() the underlying table(s) and requery the view. If it's a cursor, however, and you created that cursor yourself with the CREATE CURSOR command, this doesn't apply -- since the cursor has a disk presence just like a regular table, you should be able to permanently delete the row with the

DELETE IN MyCursor

command just like you would with a regular table. I believe this also applies in VFP 7 if you use the READWRITE option of the SELECT...INTO CURSOR statement, although this would NOT update the underlying table(s) of that SELECT.

HTH.

>Hi All. Is there any way or workaround to get rid of deleted record permanently from cursor or view without redefining the cursor or requerying the view.
>
>Thanks for your help in advance
>Mark