Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Simon Arnold
  Where is Simon Arnold?
 Halifax
 United Kingdom
 Simon Arnold
 To: Costas Loizou
  Where is Costas Loizou?
 Nicosia
 Cyprus
 Costas Loizou
 Tags
Subject: RE: Problems with Wireless NetWork
Thread ID: 50994 Message ID: 51066 # Views: 2 # Ratings: 0
Version: Visual FoxPro 8 Category: Operating Systems
Date: Wednesday, September 08, 2004 4:25:53 PM         
   


> > > Costantinos
> > >
> > > A Customer of mine, installed a wireless network. From that point starts comming a lot of problems with my POS application.
> > > Corruptet files and etc. Is there any way using the advantage of ON Error to detect this situations (Terminal Loosing the connection with the server for few seconds) , prompt warrning or doing something anyway to protect my Data.
> > >
> > > Thanks
> > >
> > > Note: Inside my POS i am using tools like CMrepair and i am correcting the problems. I need a mechanism to avoid such problems.
> > >
> > >
> >
> > See thread 50364.
> >
> > KTB
>
>
> Costantinos
>
> Thanks Ken, but what i realy want is a mechanish to check if Data on Server are available. If Not Retry .
>
> See thread 50364 = I do using FLUSH and i minimized error more than 95 %.

If you are using VFP 8 I would suggest you look at the TRY...CATCH syntax, as this would be better than trying to use the ON..ERROR statements,
I have used this method with an XML messaging system, which had to check if it had lost the connection, if so then retry the connect method.

For Example:
LOCAL loEx AS Exception

TRY 
	ThisForm.CheckConnection()
	...
CATCH TO loEx
	MESSAGEBOX("Problems with Connection: " + CHR(13) + ;
		loEx.Message + CHR(13) + ;
		TRANSFORM(loEx.ErrorNo) )
ENDTRY



Once you find the appropriate Error for the lost connection, you can then trap just that Exception with
CATCH TO loEx WHEN loEx.ErrorNo = (ErrorNumber)

Hope this helps.
Simon Arnold.


ENTIRE THREAD

Problems with Wireless NetWork Posted by Costas Loizou @ 9/7/2004 6:47:16 PM
RE: Problems with Wireless NetWork Posted by Ken Blum @ 9/7/2004 7:35:00 PM
RE: Problems with Wireless NetWork Posted by Costas Loizou @ 9/8/2004 8:16:28 AM
RE: Problems with Wireless NetWork Posted by Simon Arnold @ 9/8/2004 4:25:53 PM
RE: Problems with Wireless NetWork Posted by Mz @ 9/9/2004 9:44:27 AM