form updates optional integer column to "0", why?

Applications Forms
#1

I have a table (see ddl code below). I create a simple form on this table, accept all defaults and generate the application. When I insert records but leave cus_id empty, it inserts 0 in the cus_id column !?@$%

What is happening in the application here? the column accepts null values, I can insert them directly in the tabel using phpmyadmin.

Create table orders (
orderid INT not null
, sometekst varchar(100)
, cus_id INT null
, primary key (orderid)
)

Is this a bug? if so, is there a simple workaround?

#2

Re: form updates optional integer column to “0”, why?

Have a look at:
http://www.scriptcase.net/forum_en_us/index.php?topic=1329.0

Regards,
Scott.