I have a windows app hitting a sql server database. The app allows for inviting customers to events (Golf,Racing,etc). I need to add up to 10 activities for the spouses to attend. In the database I have added columns Act1,Act2,etc. In a form I have a listview that allows for adding and deleting activities.
The problem: Let's say I add 8 activities. I decide later to delete the first 4 and add 3 more. What code would allow me to determine where to insert the new activities.
After deleting the first 4 that left data in fields Act5,Act6,Act7,Act8. I need code (vb6) that will help me determine where to insert the next activity. Ideally I could move the existing activities up as one above it is deleted. That way they would show up in the proper order in the listview.
Hope this makes sense.