>>IF Statement Doesn't Seem to be Working
>>
>>I have numeric fields in a table of employee absence data as follows ...
>>
>>Abs.late
>>Abs.absent
>>Abs.early
>>
>>I have written an error-checking IF statement that doesn't seem to be working, but yet, VFP does not generate an error on it either.
>>
>>
>>IF Abs.late=0 AND Abs.absent=0 AND Abs.early=0
>> MESSAGEBOX('You need to make a non-zero entry') + CHR(13) + ;
>> 'in either Late:, Absent:, or Early:', 0+48+0, 'Error')
>>
>>
>>Even if the fields Late, Absent, & Early contain zeros (0.00), this MESSAGEBOX never gets processed, the program just goes right on as if everything is fine.
>>
>>Need help. TIA, CH.
>
>0.0 and 0 is no difference at all.
>
>I suspect the pointer is not sitting on the desired record. However, try:
>
>
>
>IF Abs.late==0 AND Abs.absent==0 AND Abs.early==0
> MESSAGEBOX('You need to make a non-zero entry') + CHR(13) + ;
> 'in either Late:, Absent:, or Early:', 0+48+0, 'Error')
>
.NULL. value?
IF (Abs.late==0 OR ISNULL(Abs.late)) AND ;
(Abs.absent==0 OR ISNULL(Abs.absent)) AND ;
(Abs.early==0 OR ISNULL(Abs.early))
MESSAGEBOX('You need to make a non-zero entry') + CHR(13) + ;
'in either Late:, Absent:, or Early:', 0+48+0, 'Error')
ENDIF
If we exchange an apple, we both get an apple.
But if we exchange an idea, we both get 2 ideas, cool...Gérald Santerre
Independant programmer - internet or intranet stuff - always looking for contracts big or small :)
http://www.siteintranet.qc.ca