Filling only the empty fields?

[El_Pablo]

Hi,

Is there an efficient way to write into empty fields only?

Instead of writing a bunch of

if [isempty(tableB::fieldA)]

   Set Field [tableB::fieldA; tableZ::fieldZ]

end if

I'm writing a script to allow user to start filling automatically the new database seamlessly.

The old database was not normalized (18 years old project!!) and I create a new one which respect most DB standards. So I need an efficient script to transfert data from table_old to table_new_A, table_new_B, so on.

Thanks for any help

[El_Pablo]

A way to shortened the script, is to use the case function which gives me something similar to

Case (IsEmpty (tableB::fieldA); oldTable::oldField; tableB::fieldA)