Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Delete records in grid and compute total
Message
From
30/09/2004 08:30:38
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
30/09/2004 01:42:03
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00947104
Message ID:
00947474
Views:
30
You have to SET DELETED ON (in Form.Load()), to hide deleted records.

Also, after deleting a record with DELETE, you have to do something like this:
delete
skip
if eof()
  go bottom
endif
ThisForm.Refresh()
If your deleted records are hidden (with SET DELETED ON), you can COUNT to see how many records you have. But note that after doing this, you will be at the end of the table. Depending on what you want to do, you may want to go back to top, or back to the record where you where before.

>hi,
>
>thisform.grid1.Refresh && i append this statment from(mr.Terry Thurber) it works,
>
>but still i need some help for...
>if i delete 1 records or more ,how i can resort number of records at mygrid.
>
>at this form.text7.value
>... operatins
>COUNT TO S
>s=s+1..........records counter
>
>thanks
>best regards
>m.qasem
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Reply
Map
View

Click here to load this message in the networking platform