What I want is to be able to change the data in a database without having to refresh the whole database as these looses the current navigation marker within the database.
Let me explain with an example:
I have a database/category called shows.
I then have an overlay filter screen that filters on show name.
This gives a screen with a list of episodes of that show:
4x01 episode 1
4x02 episode 2
When I select a show to watch it I call a background VB script that finds the %file% in the shows.xml and adds a field <status>_</status> to the db, then performs a refresh database.
This adds a _ to a show once you have watched it, so list now looks like:
_4x01 episode 1
4x02 episode 2
..but as the category has to be refreshed to bring in any changes to the xml file it looses its current marker in the category and the filtered list, so reverts back to a first load situation list:
show1
show2
show3
......
This was a first draft proof of concept before Steven adds support for 2 graphics per record, I could then use one as a thumb image and create more of a Tivo look with green balls for new, red balls for watched, etc....
In order to achieve this I need to be able to alter a Db in memory, then commit the changes to the xml. FYI, this is the behaviour if you hit F2 and change some database elements, so the functionality is there, just needs exposing as an event.