>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
I haven't had much time to think about your problem. but since it's a hurry I thought I'd come with the first thought I came across, namely to delete the record in another fashion, the way I use to do. I never had any problems, so it might be worth a shot.
select entry
locate for entryid = m.lckeyvalue
delete
select entrydet
locate for entryid = m.lckeyvalue
delete
BTW, what version of Fox is it? Any referential integrity in the database that might prevent you from deleting. Is there any, and if "yes", what kind of relation between those tables?
Best regards
Danijel