Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
0, .NULL., EMPTY() numeric field
Message
 
To
22/05/1999 08:51:10
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00221542
Message ID:
00222043
Views:
24
>Bulls Eye Cindy !
>Excellent :) I couldn't think this yesterday. Numeric fields could only be visually blank and distinguished with isblank().
>Cetin

ISBLANK(quantity) is returning .F. for these blank values. The records were originally created with INSERT INTO mytable (someotherfield) VALUES(someothervalue). Of course, neither this command nor any other one specified the value of the quantity field.

I just tried APPEND BLANK and then BLANK FIELDS quantity. The expression ISBLANK(quantity) returned .F. after each of those commands.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform