calculating text-fields

[Harjo]

Hi,
I have three text fields: titel, voorletter, achternaam
I have one calculated field(stored): naamcompleet:

return titel + " " + voorletter = " " + achternaam;

Oke that works, but if one field is null (not filled in!) the calculation returns: null in text format.
Is there something to be done? or do have to check every field for empty and null values?

BTW the values don't become empty when I only click in and out of a field. I have to put some text, delete it and then it becomes empty. is this normal?

[Ron]

No you don't have to check this.
You simply have to be sure the ALLOW NULL box is empty in the
dataproviders/column_tab!!

[Harjo]

Jan/Maarten/anyone,

Is this the best solution? or are there other ones?

[Jan Aleman]

The checkbox ALLOW NULL has a very different purpose. 'ALLOW NULL' means that a value is ALLOWED to be NULL and nothing more or less.

We are looking into parsing null's differently so that you don't get null in your strings if you concatenate. We don't know yet if that will make it into 1.1 final. For the time being you will have to use mergefields to acoomplish this or use if's in your calc to check for null

[Harjo]

The suggestion of Ron works fine, until I restart Servoy Developer!
All my fields are checked with: ALLOW NULL again!!!

Is this a bug?

[jcompagner]

in RC4 null values of strings are concated as empty strings now.
So no need to check for null anymore when you want to concat strings.