The safest bet is to always assume the remote connection is down. You will need a local database. You write to the local database, then use a job to sync it to the main database. The job should stop if and error silently if it can not connect to the remote host. The remote host should send a handshake back that the entry was accepted so it can be deleted locally. This is how every POS I have seen run works.
Sign in to participate in this thread!
We'd like to thank these amazing companies for supporting us