I want to keep a database open during the life of my program and also keep a record open over some period of time as each record has to read quite a few times and I'd like to minimize to number of record openings and closings.
In order to do this I have set up a number of variables to keep track of whether the database is open,what it's DbReference is, whether there is a record open and crucially what the index of the record is. My question is, can I rely on the index remaining the same while I have it open? I know the recrd index is a finicky thing and I can't be certain on it remaining constant due to is being resorted or reindexed at every delete or new view, but can I rely on it reamining constant over the life of my program. In particular, what actions may make it change? (By the way, as I have to keep track of certain records I record their unique IDs between executions as these remain constant. I do not want to do this during the program remaining open as to open a record using a unique ID seems to be a very proccessor consuming task and I'm trying to speed up my program.) -- thanks, Ash. -- For information on using the Palm Developer Forums, or to unsubscribe, please see http://www.palmos.com/dev/support/forums/
