Hi,
If a deleted record in cursor (you delete record if you mark the delete column in a grid) is visible, depends on the settings of SET DELETED. IF SET DELETED ON, then after a while (check SET REFRESH)or after scrolling deleted records will be hidden from display.
HTH
Agnes
>Dear All,
>
>This seems to me as bug in VFP7. I am running VFP7 SP1 and my client wants to have ability to selectivly delete records from the grid.
>Problem:
>Client ( VFP7 ) is running remote view against VFP database ( VFP7 SP1)
>I am running remote view with TABLEBUFFERING and multilocks ON.
>My grid is read only and i made the property DeleteMark=.t. so the user can selectivly mark for deletion records and then by clicking on Delete button i just run TABLEUPDATE(.T.,.T.) and requery the remote VIew.
>
>In my grid i display only up to 5 rows at the time because the height of the row is 70. SO user has to scroll up and down if they want to mark records for deletion. I noticed when i click on up/down scrollbar arrows the records i had marked for deletion start disapearing. My client certainly want like this "feature". Is there a fix for this or someother way of doing it.
>I put the button to undo changes just run TABLEREVERT(.T.) but it is anoying and i have to find another solution.
>
>I think i will have to come up with my using hidden field in my table instead relying on VFP7 delete mark.
>Also i need to be able to count correctly of how many records have user marked for deletion.
>
>Any idea is much appreciated?
>How does one deal with selectivly deleting records from the grid ( readonly) in multiuser environment?
>
>
>Thanks
>
>Dejan
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]