Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Best way to determine if memo field has data
Message
 
 
To
30/05/2002 17:20:10
James Blackburn
Qualty Design Systems, Inc.
Kuna, Idaho, United States
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00663208
Message ID:
00663219
Views:
16
>>>Is there an easy way to determine if a memo field in a remote view (SQL Server 2000 data) has any data? I want to change the color on a command button if there is anything in the memo field. Any ideas?
>>
>>Did you try EMPTY() function?
>
>I would test for isnull() as well. My experience is empty() will return .f. with null value.

EMPTY() function returns .F. for Null value because Null represents unknown value not empty one.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform