Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Deleting Records of a Grid
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00639637
Message ID:
00640306
Views:
20
Nancy,

What is the buffering for the view? It sounds like you have buffering set to 3...

Also try to move focus off the grid and then back to the grid...

I believe, I saw problems like yours here and in another forum, but I don't remember, if there was a good solution for them...

>>
>>Don't pack inside the form, just do delete, then go recno(), then refresh()
>
>Nadya,
>
>I saw your reply to Mike Smith about the grid refresh problem after deleting a record. I'm having a similar problem. The difference in mine is that the record will be marked deleted but after refreshing the grid, the deleted record still appears in the grid. (I have SET DELETED ON and I'm' using an updatable view, but I'm not doing a tableupdate() until the user has completed all modifications to the page currently displayed.) The really frustrating part is that it doesn't happen consistently! It seems to happen only when there are more records than can be displayed in the viewable part of the grid -- but not if there's only one more record than can be displayed.
>
>I was moving the record pointer to force the record to "disappear" using SKIP (with test for EOF, etc), then refreshing. I changed to your suggestion of go recno() before the refresh, but still (sometimes) see the record. I've also tried go top, with same results. I suspended the program immediately after the refresh() to see how the data actually looked. Browse does not show the deleted record. But I can click on the grid row that is displaying the deleted record - and upon then clicking my Delete command button, I get "Update Conflict." That error occurs on the command that is trying to move the record pointer (skip, go recno(), go top).
>
>I'd really, really appreciate any ideas on how to resolve this one.... I'm stuck! BTW, I'm using VFP 6, SP5.
>
>TIA,
>Nancy
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform