Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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?
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement