Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to NOT stop the Select SQL?
Message
From
28/01/2005 08:44:58
Mike Yearwood
Toronto, Ontario, Canada
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
00980904
Message ID:
00981675
Views:
42
By the way, Nadya

This code has a problem.
LPARAMETERS nError, cMethod, nLine, tcSys16, toErrObj
IF m.nError = 1839 && Requery cancelled	

	IF VARTYPE(m.plStop) = "L" AND m.plStop 
		* Have we stopped already?
	ELSE
		RETRY
	ENDIF
ELSE
	DODEFAULT(nError, cMethod, nLine, tcSys16, toErrObj)
ENDIF
I think you should code it like this...
LPARAMETERS m.tnError, m.tcMethod, m.tnLine, m.tcSys16, m.toErrObj
IF m.tnError = 1839 && Requery cancelled	

	IF VARTYPE(m.plStop) = "L" AND m.plStop 
		* Have we stopped already?
	ELSE
		RETRY
	ENDIF
ELSE
	DODEFAULT(m.tnError, m.tcMethod, m.tnLine, m.tcSys16, m.toErrObj)
ENDIF
Because! nError with or without the mdot is possibly a field name in some naming conventions. You can run into a conflict. Further, you are mixing different types of notations. nError and toErr. Every parameter is supposed to be prefaced with "t". You can and IMO should name them properly.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform