Hello. Long ago I developed an application with alphafive (9 for windows) for a friend he recently asked for a feature update.
He is a doctor that work with a partner at small office. The application I developed is basically a database with medical history of patients.
The problem is that one of the doctors sometimes goes out in the field to remote locations in other villages without reliable internet connections.
So he wants to use the app on the field to enter information for new patients then go back in the office and update the office database with the new records.
In the past he handle this with a simple backup utility, but now a partner might be in the office using the database and enter new patients or updating old ones.
So in summary, what is the best pratice to update just the new records collected on the field on the main database. The main field now is patienID which is autoincremental
Imagine that the last patient was number 5780. Then doctor goes in the field and open a new record for patient 5781 while the other doctor in the office do the same with a new patient which
will have the same 5781 id. If he does a simple backup he will overwritte the records on the main database in the office.
I am sure this is a basic feature, but I have not done any database development in years and now trying to help out a friend.
Thanks so much for your suggestions!!
He is a doctor that work with a partner at small office. The application I developed is basically a database with medical history of patients.
The problem is that one of the doctors sometimes goes out in the field to remote locations in other villages without reliable internet connections.
So he wants to use the app on the field to enter information for new patients then go back in the office and update the office database with the new records.
In the past he handle this with a simple backup utility, but now a partner might be in the office using the database and enter new patients or updating old ones.
So in summary, what is the best pratice to update just the new records collected on the field on the main database. The main field now is patienID which is autoincremental
Imagine that the last patient was number 5780. Then doctor goes in the field and open a new record for patient 5781 while the other doctor in the office do the same with a new patient which
will have the same 5781 id. If he does a simple backup he will overwritte the records on the main database in the office.
I am sure this is a basic feature, but I have not done any database development in years and now trying to help out a friend.
Thanks so much for your suggestions!!
Comment