Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Deletion problem
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00226715
Message ID:
00226731
Vues:
21
Lori, are you doing the deletions on the VIEWS or the base tables? If the views, then you need have NO BUFFERING on the base tables or add a tableupdate for the base tables.

HTH
Barbara

>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?
Barbara Paltiel, Paltiel Inc.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform