FieldIsNull on alliased fields
rotursoft
Slovakia
Hi all!
I tried to use FieldIsNull and I got this experience:
DatumVratenia.Lines.Clear;
if not [FieldIsNull('ib1."DATUM_VRATENIA"')] then
DatumVratenia.Lines.Add([FORMATDATETIME('dd.mm.yyyy',[MASTER."DATUM_VRATENIA"])]);
^^^ this code is working fine, but
I very often use alias names for fields, because I sometimes use report from more parts of my programs and datasources names may be different but alias is always equal from these parts. If I try to use in FieldsIsNull function field with alias notation, function always return same result.
Why?
I tried to use FieldIsNull and I got this experience:
DatumVratenia.Lines.Clear;
if not [FieldIsNull('ib1."DATUM_VRATENIA"')] then
DatumVratenia.Lines.Add([FORMATDATETIME('dd.mm.yyyy',[MASTER."DATUM_VRATENIA"])]);
^^^ this code is working fine, but
I very often use alias names for fields, because I sometimes use report from more parts of my programs and datasources names may be different but alias is always equal from these parts. If I try to use in FieldsIsNull function field with alias notation, function always return same result.
Why?