Sorry Agnes, that's supposed to be for Dejan.
>Or in your remote View add an expression i.e. 0 As DeleteMark instead of adding field to your table.
>
>>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
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."