Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
If statement to check for exclusive?
Message
 
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01308043
Message ID:
01310918
Views:
19
I am trying to solve this problem here again. I decided to change my route of thinking on the subject. There is an employee lookup table that is used to determine of the employee has access to the database as well as to assign what level of access they have if they are allowed. I added a field to this table simply called "update." I now have the update program set update to True for all employees who have access to the database. Now in my main start program, I first load in the employee look up table and check to see if update is set to true, and then tell it to quit if it is set. However, it seems to ignore this. I have checked, and while the update program is running, all employees correctly have their update field set to True. Any ideas as to why this might not be catching this?
	USE employee_lookup
	LOCATE FOR ALLTRIM(number) = LEFTC(ALLTRIM(SYS(0)),9)
	IF FOUND()
		STORE access TO m.dbaccess
		STORE access2 TO m.dbaccess2
		STORE access3 TO m.dbaccess3
		STORE update TO m.update
		
		IF (m.update = .T.)
			MESSAGEBOX("Administrators are currently performing maintenance on the database. If you have any further questions, please contact one of the administrators.")
			QUIT
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform