Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Deletion problem
Message
From
04/06/1999 19:21:26
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Deletion problem
Miscellaneous
Thread ID:
00226715
Message ID:
00226715
Views:
73
I have a modal screen that displays two list boxes that the user can add and remove clients. When I add clients the procedure works fine, but when I delete clients with the following code:

delete for alreadyclients.id = nowid
sele appclient
=cursorsetprop('Buffering', 5, 'appclient')
delete for ((appclient.appraiser_id = mainid) and (appclient.client_id = nowid))
=tableupdate(.T., .t., 'appclient')
LIST FIELDS appclient.appraiser_id, appclient.client_id FOR DELETED( )

The main table that holds the one to many relationship between the appraiser and the client, does not mark the record for deletion. I am working with two cursors that hold the lists. Could they be blocking the records being deleted? Or, is there something else I need to do to ensure the records in the permanant table are deleted?
Next
Reply
Map
View

Click here to load this message in the networking platform