Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using the FIELD() function and REPLACE
Message
 
To
27/07/2000 09:36:08
Raymond Humphrys
Michigan Department of Community Health
Bath, Michigan, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00397520
Message ID:
00397562
Views:
13
>Strange. I'm looking at the table and the see that the column is blank and the following happens:
>
>? isnull(eval(field(1))) Returns .f.
>? empty(eval(field(7))) Returns .t.
>
>>>? isnull(field(7)) OR isnull(field(i))) if looping ...
>>>
>>>>ISNULL()
>>

>>ISNUL( EVAL( FIELD(i) ) )

Raymond,

If a field is NULL it is not empty (both EMPTY() and ISBLANK() will return .F.). If EMPTY() or ISBLANK(), it is not NULL.
George

Ubi caritas et amor, deus ibi est
Previous
Reply
Map
View

Click here to load this message in the networking platform