Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Listbox
Message
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00210043
Message ID:
00210052
Views:
28
>Hi,
> I have a listbox that display mytable. I want my listbox to able to display the record no. at the front of records shown in my listbox. The following is what I put in RowSource and RecordSourceType was set to 2.
> alltrim(str(recno())+'.'),filename,fullpath
> When I issue delete command to my table, record deleted but the record no. are not changed as shown as before deleted. Again, when i click on the listbox after delete, the value in listbox before this shown highlighted with grey colour. How to solve it?

That's normal table/delete behavior. Deleting a record does not cause the table to be renumbered. You might use a View with a REQUERY() each time a deletion is made...there are other ideas too, I'm sure...once you know that this is the problem. You need to do a complete re-numbering of your list somehow.
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform