RE: data base access
- Posted by Jonas Temple <jktemple at yhti.net> Aug 03, 2001
- 421 views
George Walters wrote: George, Being that I have spent a lot of time with database.e developing similar apps to what you're working on I wanted to interject my thoughts: If you are developing MULTI-user business apps (they are usually mult-user) with straight database.e then you are going to run into trouble. The docs pretty much spell out that database.e is not intended for multi-user access. Files opened with database.e don't share well and using record numbers to access data will eventually crash your progrram if you have more than one user accessing the same file. I suggest you check out me EDS/Net package on the contributions page. This allows multi-user access of database.e functions across an IP network. It's by no means perfect but it seems to be pretty stable. Your wish list of additional functions: > ic_record = db_read( db_opened_table[x], item_key) -- with one read and > items 1-4 be taken care of internally. > ic_record = db_readnext(db_opened_table[x]) -- to provide the next > ic_record = db_readprev(db_opened_table[x]) -- to provide the > previous > db_add_record(db_opened_table[x], ic_record) -- adding to file > db_update_record(db_opened_table[x], somePartKey, somePartRecord) > db_delete_record(db_opened_table[x], somePartKey) are there as well! I am committed to continue improving EDS/Net. I am currently working on speeding up record retrieval for large number of records. The administration interface is also going to get a re-write. Try it and see if it works for you. I would also welcome any suggestions/feedback. Good luck. Jonas