Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Deletion problem
Message
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Deletion problem
Divers
Thread ID:
00226715
Message ID:
00226715
Vues:
72
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
Fil
Voir

Click here to load this message in the networking platform