Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multiple mark for deletion in grid
Message
 
 
To
23/06/2003 04:08:06
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00802806
Message ID:
00802817
Views:
25
Instead of using DELETEMARK of the grid, add field to your table to be used as marker for deletion. Then upon clicking the button, you can make use of the DELETE FOR statement to delete the records before issuing TableUpdate().

>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."
Previous
Reply
Map
View

Click here to load this message in the networking platform