André, try this:
If [your_table_name::field A = 0 and your_table_name::field B = 0 and your_table_name::field C = 0]
Set Field[your_table_name::field Z ; 0]
Set Field[your_table_name::field Z ; 1]
Note: Fields must be type "Number"
I will, thanks!
...and that doesn't have to be a script step, from what you have described. You could just make it a calculation field:
Field A = 0 and Field B = 0 and Field C = 0 ;
I always prefer to use Case over If in a calculation. And a calculation is generally better than setting field values by a script step, as the method is more reliable.
Good to know! As I'm learning I'll try both ways so I can learn more!