Re: v13 - Null values

2018-06-04 Thread Chip Scheide via 4D_Tech
Pat, the reason I am looking to test for 'Null' is I have a utility utl_Is_Empty(->Var_or_Field) --> boolean This utility returns true if the field or var is 'empty', if the value is a default empty value for the field or var type (i.e. text = ""). However, as I mentioned before, something

Re: v13 - Null values

2018-06-03 Thread Pat Bensky via 4D_Tech
Maybe try something like this: - Set an error handler - Try to use that field or variable - If it is null then the error handler will catch it eg: ON ERR CALL("errorcatcher") $result:=$BooleanVarOrfield=true ON ERR CALL("") On 2 June 2018 at 15:02, Arnaud de Montard via 4D_Tech

Re: v13 - Null values

2018-06-02 Thread Arnaud de Montard via 4D_Tech
> Le 1 juin 2018 à 20:39, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > I meant - I was looking for a command which behaved like Nil(), but for > Null. Hi Chip, I had a bad recent experience with a legacy db in which check box "convert Null to empty" was sometimes on,

RE: v13 - Null values

2018-06-01 Thread Chip Scheide via 4D_Tech
I meant - I was looking for a command which behaved like Nil(), but for Null. :) On Fri, 1 Jun 2018 17:26:26 +, Timothy Penner via 4D_Tech wrote: >> I was looking (in v13) for a boolean test like Nil(). > > Oh yeah, not sure how I missed that. Keep in mind that the Nil > command was

RE: v13 - Null values

2018-06-01 Thread Timothy Penner via 4D_Tech
> I was looking (in v13) for a boolean test like Nil(). Oh yeah, not sure how I missed that. Keep in mind that the Nil command was renamed to "Is nil pointer" in v16R4 http://livedoc.4d.com/4D-Language-Reference-13.6/Language/Nil.301-2502515.en.html

RE: v13 - Null values

2018-06-01 Thread Chip Scheide via 4D_Tech
Thanks I was looking (in v13) for a boolean test like Nil(). On Fri, 1 Jun 2018 17:10:32 +, Timothy Penner via 4D_Tech wrote: > Hi Chip, > >> Is there a means to test for a 'Null' value in v13? >> By 'Null' do not mean the default (type appropriate) value of an >> unassigned field or

RE: v13 - Null values

2018-06-01 Thread Timothy Penner via 4D_Tech
Hi Chip, > Is there a means to test for a 'Null' value in v13? > By 'Null' do not mean the default (type appropriate) value of an unassigned > field or variable. > If not, at what version does this capability exist? In v11 the commands SET FIELD VALUE NULL and IS FIELD VALUE NULL were added:

v13 - Null values

2018-06-01 Thread Chip Scheide via 4D_Tech
Is there a means to test for a 'Null' value in v13? By 'Null' do not mean the default (type appropriate) value of an unassigned field or variable. If not, at what version does this capability exist? Thanks Chip --- Gas is for washing parts Alcohol is for drinkin' Nitromethane is