Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How can I validate .NULL.?
Message
General information
Forum:
Visual FoxPro
Category:
Other
Title:
How can I validate .NULL.?
Miscellaneous
Thread ID:
01194806
Message ID:
01194806
Views:
56
Maybe it´s a silly question, but I´m having some trouble to validate a NULL value. I´m taking data from a Excel Worksheet, don´t knowing how large is it. So, I need to break my DO WHILE when the program finds a blank cell. My code is something like this.
	DO WHILE .T.
		micontrol = .cells(lnfila,2).VALUE
		IF micontrol = .null. then
			EXIT
		ENDIF
                *....
                *Some code that works fine...
                *....
        ENDDO
Everything works fine, but I never can reach EXIT, and the other code continue excuting, logically sending me an error. Using the debugger, the value for micontrol is .NULL.

What's wrong??

Thanks in advance!
By two common phrases in his vocabulary, we know Hercule Poirot was a great Developer: his use of "the little grey cells" and "order and method".
Next
Reply
Map
View

Click here to load this message in the networking platform