General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only