Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Deletion problem
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00226715
Message ID:
00226731
Views:
22
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform