Mind you that the i am aiming for the vast majority of data handling to be dealt with by a dll file that i also am working on.
well it needs to open the database files for the requesting program, I know that this is a bit taxing on memory, but, I think it will be easier to work through the database files. I also am working towards putting more information in fewer files, so fewer files have to be opened.
It needs a search function,,, (the one i have been working on only pulls exact matches, i am trying to find a way to figure a wildcard for general searches... none so far have been successful. They either work with one item or none...)
It needs to have a function for each item: Move first, Next, Prev., Move last, Add, Edit/Update, and delete/remove records for fields.
It needs a function for sending information back to the specified application.
It would be nice if i could get some of the fields indexed, so that searching is quicker and easier... Just a nice thought...
It needs a way to detect when the files need to be closed so that some other instance can open the database.