After your delete statement issue
=RLOCK()
UNLOCK
I have found that this forces your computer to re-read the latest information.
HTH
//;^)
>I have a complex wee form by my standards. A big feature is a grid which gives thisform.keyvalue the primary key of a view.
>
>The view is never edited, instead all the form fields point back to the original tables - the view does some complex concatenations etc.
>
>I have a delete button which verifies if the user really wants to delete and then
>
>
select entry
>delete from bkdata!entry where entryid = m.lckeyvalue
>
>select entrydet
>delete from bkdata!entrydet where entryid = m.lckeyvalue
>
>=requery('ventry')
>thisform.pgfEntry.pagPick.grdEntry.refresh()
>
>However, the record in entry doesn't delete. It does if I click in a browse window but not from the command line etc. I've got m.lckeyvalue in there as I wondered if thisform.keyvalue was prohibited. Very confusing.
>
>i need to get this sorted in a big hurry so will really appreciate any suggestions.
>
>Sarah