If you are using Chameleon's version 5.0 parser engine to write data to a database table, assigning 0 to the value variable in a Table Inbound Script might not produce the behavior that you are expecting:

value = 0

When you attempt to assign 0 to value in a Table Inbound Script, the 5.0 parser engine actually assigns the Python None object to value (in versions of Chameleon prior to 5.1.10 that support the 5.0 parser engine). This means that the database field to which the table column is mapped will contain null, not 0.

The easiest way to work around this problem is to use a Segment Inbound Script instead of a Table Inbound Script. In the segment field that will be mapped to the table entry, define the following Segment Inbound Script:

if value='':
	value = '0'

This will ensure that your database field is assigned 0, not null.

	In versions of Chameleon starting with 5.1.10, the behavior of Table Inbound Scripts has changed. If you define value = 0 as a Table Inbound Script, value is assigned 0, not null.