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."