MySQL Forums
Forum List  »  General

Re: Save data in a flatfile
Posted by: Peter Brawley
Date: February 01, 2020 04:39PM

It's a common problem. The flat file wouldn't be ideal. The standard method, I think, is ...

(i) create a data input app that runs on salesreps' laptops implementing all necessary business rules to save new rows to a laptop db which runs a local installation of mysql against tables required for input,

(ii) give the app that runs in the main app the ability to access any given salesrep's laptop db, import data from that db into the main db and log the event, then truncate the laptop db making it ready to repeat the cycle.

Options: ReplyQuote

Written By
February 01, 2020 03:39PM
Re: Save data in a flatfile
February 01, 2020 04:39PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.