Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Delete records in grid and compute total
Message
From
03/10/2004 07:58:46
 
 
To
03/10/2004 07:40:31
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00947104
Message ID:
00948308
Views:
35
Oh! I think I see. You are displaying a "record number" in the grid - but it is not really a record number because it does not include the deleted records!

i don't want to see at mygrid itemno as
                            2
                            3
                            5
                            6


If this is correct, I assume that you have a field in your grid's RecordSource called Item_Number. If this is true, you need to renumber all of the item numbers after you delete records like this:
lnItem_Number = 0
SELECT ( Thisform.Grid1.RecordSource )
SCAN FOR NOT DELETED()
  lnItem_Number = lnItem_Number + 1
  REPLACE Item_Number WITH lnItemNumber
ENDSCAN
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform