Boolean won't insert if default is "true"

[nick]

Hi

What is the proper way of setting a boolean column (checkbox) to
"true" by default? It seems that the datagrid won't accept inserts if
the default is true.

BoolColPaid = new DataGridBoolCol umn();
BoolColPaid.Map pingName = "paid";
BoolColPaid.Hea derText = "paid";
BoolColPaid.Fal seValue = false;
BoolColPaid.Tru eValue = true;
BoolColPaid.All owNull = false;
BoolColPaid.Nul lText = true.ToString() ;
BoolColPaid.Nul lValue = true;

Here's defining the dataset's paid column:
<xs:element name="paid" type="xs:boolea n" minOccurs="0" />

Here's setting the paid column's default to true:
dataset1.Tables[0].Columns["paid"].DefaultValue = true;

I'm using Access database.

[nick]

On Fri, 13 Feb 2004 14:41:54 +1300, nick <[e-mail]> wrote:

Hi

What is the proper way of setting a boolean column (checkbox) to
"true" by default? It seems that the datagrid won't accept inserts if
the default is true.

BoolColPaid = new DataGridBoolCol umn();
BoolColPaid.Ma ppingName = "paid";
BoolColPaid.He aderText = "paid";
BoolColPaid.Fa lseValue = false;
BoolColPaid.Tr ueValue = true;
BoolColPaid.Al lowNull = false;
BoolColPaid.Nu llText = true.ToString() ;
BoolColPaid.Nu llValue = true;

Here's defining the dataset's paid column:
<xs:element name="paid" type="xs:boolea n" minOccurs="0" />

Here's setting the paid column's default to true:
dataset1.Table s[0].Columns["paid"].DefaultValue = true;

I'm using Access database.

Sorry it was something else.