>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
Hi Sarah,
It should be around midnight there. Still working ? and not solved ? Form and command window might seem to behave differently if form has private datasession and buffering is in effect. Views are always buffered but here case doesn't seem to be related with that (requery()), rather buffering of tables. Your click code could be like this (view never edited):
delete from bkdata!entry where entryid = m.lckeyvalue
delete from bkdata!entrydet where entryid = m.lckeyvalue
=tableupdate(.t.,.t.,"entry3")
=tableupdate(.t.,.t.,"entrydet3")
=requery('ventry')
thisform.pgfEntry.pagPick.grdEntry.refresh()
Cetin