N/APosted on - 03/07/2012
Hi have a database. But I have a bug which updates the POS terminal but doesn't update the main database. I have searched all the link connections in the system. Can't identify it? IF you want, I'll attach a system organization chart.
Doesn’t update the main database in the store
As far as I have studied the course, first you have to make sure the following things are present inside the whole system.
Make sure that the Main computer in the server room is not the POS for any kind of relationship. Note that if you have more than 1 POS, you must explicitly define relationship of each one of them with the main system.
Make sure that you have correctly used the joints and primary keys.
Make sure that you are using correct foreign key imports.
Make sure that your internet or lan connection between main server and POS is functional and working.
Do all these things and I hope that you wont be seeing the problem again.