1

Loop not clear
Hi there,
Although loops are explained in your manual, it is not yet clear how you would, for example, in a table called "contacts" with only "firstname" and "lastname" but where some firstnames are missing (empty), fill in the missing information with "Norbert" ?
Thanks for your help
Like Follow 1
3replies
-
Yeah the manual is not very good.
You can try something like:
let loop1 in select contacts[firstnames = null] do loop1.firstnames := "Norbert" end
or if you have your select in a variable already you can do:
let x := select contacts let loop1 in x[firstnames = null] do loop1.firstnames := "Norbert" end