buymeapc wrote:How can that be accomplished?
Its is rather complicated but it is possible. Im doing it in ZPd it takes some video relevant data from zoomplayer and saves those values in fields of DB.
Long story short: U need a cat which represent the database, it can be dummy though (meaning it exist in hidden location) then u have to locate the relevant item from that cat. If DB is flat (meaning no subitems) it is easy and can be accomplished trough regular catwalking, just like in Pittaways MoveTo plugin. If DB is deep (meaning items on 2 or more levels) situation grows substantially more complicated, u need (dummy)cat to represent each level and u need to daisy chain these cats. Then u need multitier catwalk algorith accomplishing feat of finding item, like my recursive version of DeepMoveTo (i gave pseudocode of that algorith on some thread here) basicly its easy, there is just some hacky trickery u have to use when u change level related to the order in which and to what cat u call xlobby category methods ( i cant remember that now, but it should all be clear from that pseudocode). Allthough that algorith can in theory handle any number of levels, i havent been able to create more than two level chained cats in practise, i hope somebody finds a way or Steven fixes that. After u have relevant item as a current u need simply use category methods which allow u to put variable in cat item field. Then u have to call save to database, and then few more category methods to make current situation reflect the change (also there is some trickery attached to calling order here, which i have explained in some of my postings, but i cant remember methods or order right now).
Like i said rather tricky, but certainly possible! Well it is easy if database is flat, but if database is flat and large it can be slow, cause catwalk in flat database is inherently linear operation, if cat is deep, its harder to implement, but u can make algorithm looking for right item logarithmic, so it can be considerably faster in case of large cats.
Now i dont know what exactly u try to accomplish, mayby u have some reason for directly editing database file. Mayby what u r trying to do cannot be done quickly enough with the way i describe. but if this method of feasible, i can look for that pseudocode and check up correct calling orders for hacky parts from my code for xPerT.