Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Server shut down
Message
From
14/02/2011 11:35:17
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Server shut down
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Miscellaneous
Thread ID:
01500113
Message ID:
01500113
Views:
116
Hi friends:

I have a big experience in Clipper and Net although I have no great solutions with it. One of the problems often occur is this:

One or more PCs conected to a Server. No SQL, no famous Net software, no. Plain Windows.

You know. Someone disconnects wire, someone press reset, something "strange" happens with Windows conection and system hangs.

Workstation is working witn one or more open files. My system is on wait. Nothing happens. The user scans a barcode and the program selects one of the files open but server is not anymore... In Clipper hangs and the client calls me and tell me "I press any key once and once and nothing happens."

I don't know what happens in VFP yet, surely you do.

I don't want to open the file every time I need it. If so I use the "FILE()" function and solve the problem opening a local copy of the file.

One of my hits with clients is telling them "You change a price in one machine and every machine is updated with the new price" I enjoy when I see their eyes becoming bigger... Really? Yes. Do it. Don't believe me...

Well. All this fable for asking you:

Do you know any tips to detect if a workarea will generate an error or hangs because of this problem?

If the error occurs when I SELECT(AREA) perhaps it can be catched. That would be perfect. What I don't want is the hanging.

Thank you in advance.

Héctor
Next
Reply
Map
View

Click here to load this message in the networking platform