i am trying to insert data into a table but i am getting this error.
Field 'BIOMETRIC_FLAG' doesn't have a default value
INSERT INTO mytab (CLIENT_ID,DAD_ID,LOCATION,DESCRIPTION) VALUES (1,1,'Default','First Data Acquisition Device');
where 'BIOMETRIC_FLAG' is a field in the table and it is defined in the table as
BIOMETRIC_FLAG CHAR(1) NULL
please help me in resolvin this error.