KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
Tech Tip: Null values in numeric fields
PRODUCT: 4D | VERSION: | PLATFORM: Mac & Win
Published On: March 28, 2003
Your current browser may not allow you to download the asset. We recommend Mozilla Firefox or Google Chrome.
Log In

Version: 6.7.x, 6.8.x and 2003

This tech tip contains a simple strategy to use for those implementations where you are storing numeric values and you want a field to be empty if no data has been entered.

4D's numeric fields use zero as a null value. A strategy you might use for your implementation would be to store the data in an alpha field, since alpha fields are null if no data is entered. If you use this strategy you will have to convert the data to a numeric value for those instances where you want to do calculations.