Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
If statement to check for exclusive?
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Divers
Thread ID:
01308043
Message ID:
01311088
Vues:
29
Interesting idea to name character field Number <g>

>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
>
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform