mutating UUIDs -> Map NULL values to blank values=20

Keisuke Miyako (3/28/14 1:57AM)


Keisuke Miyako (3/28/14 1:57 AM)

The code example below would assign 0 or ?=A2?=82=C5ì?=A2?=82
=C2ù to all fields.

The only way in 4D to assign NULL is to use the command SET FIELD VALUE
NULL or SQL.

color><param>00000,0000,DDEE/param>WWhy would you want to have a field
with a null value?
/color>
when I get asked this question during 4D training, I always use the
example of exam stats.

10 people took an exam, but 5 were absent because of the flu.
you want the average marks, but unless you take into account NULL,
the average goes down because of the 0 points of the 5 absentees.

miyako

On 2014/03/28 9:46, "Tim Nevels" <timnevels@... wrote:

color><param>00000,0000,DDEE/param>SSay you turn off =A0"Map NULL
values
to blank values" for all the fields in
a table. Then you do:
CREATE RECORD([Table1])
SAVE RECORD([Table1])
You don't do any assignment of any values to any fields.
Did you just create a record in [Table1] that has every field with a
null
value?
/color>

Reply to this message

Summary created 3/28/14 at 11:34AM by Intellex Corporation

Comments welcome at: feedback@intellexcorp.com