Client/Server Approach

[butsoy66]

hi to all

I want to create a POS system with 10 workstations and a server and i want my .exe intalled locally. How to design a program even if the server is down the workstations is still working/updating the data and when the server is back it will automatically update the data to the server.

thanks in advance

 

[Scott24x7]

Well, in concept, you will need some sort of localized tables to hold data, and update your server when it is done. But if you are asking for someone to "whip up a routine" for you, this is far too complex a question to post to this form. If you are developing one, and need help along the way, please post your questions.


Best Regards,
Scott

"Everything should be made as simple as possible, and no simpler."

 

[Mike Lewis]

Your basic problem is that the only way you can carry on working when the server is down it to hold local copies of the data. But then how would each workstation update the other workstations' copies? The whole point of having a server in the first place is to centralise the data so that everyone can update it.

Of course, if you don't need to update the data in real time, you could simply store the updates locally, and then periodically upload them to the server. If the server went down, you could delay the uploading for as long as necessary. But then how would each workstation know the stock on hand? They'd have no way of knowing what the other workstations have sold. (Or maybe that doesn't matter in your system.)

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk