Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Question on Empty()
Message
 
To
03/08/2000 09:34:18
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00400312
Message ID:
00400325
Views:
23
Hi Diane,

As far as I tested your case EMPTY() correctly returns .t. I have never seen it working the wrong way.
Did you try it on another PC?
BTW, you cannot use EMPTY() with NULL values, you have to use ISNULL() function for that.

>Hi everybody,
>
>
>Can somebody can tell my why this statement returns .F. when the value is 0.00? I tough that EMPTY would return .T. when the value is null or 0
>
>The initial value is 0 then later I change it to:
>ThisForm.TxtroZeroDebit.Value = IIF(lnAmount > 0,0.00,-lnAmount)
>
>I check and recheck, the value is 0.00
>IF EMPTY(ThisForm.TxtroZeroDebit.Value)
>
>
>PS: I know how to fix it but I've seen this code in many places within my application and I wonder if I have to check ALL my forms.
>
>PSS : this code was working before, the only modification I did was how to calculate lnAmount wich should not influence anything and I also change 0 to 0.00 because I like to see 2 decimals in the field. And of course I save the form, now, I'm using FoxPro 6.0 SP3 but I don't know wich service pack I had when I last modify that forms.
>
>
>TIA
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro

"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform