Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Delete - SQL not working, Desperate Need of Help
Message
From
03/10/1998 01:12:54
Larry Long
ProgRes (Programming Resources)
Georgia, United States
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00142721
Message ID:
00143550
Views:
31
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
L.A.Long
ProgRes
lalong1@charter.net
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform