SQL Server 7.0/VB6 Problems with bit and checkboxes
I'm pretty sure it can only have one of two values, on or off,
My fix to this problem would be to put the default value of 0 in your
table. Maybe someone else has better insight to this, but that's what
I would do.
Quote:
> I'm using VB6sp4 to connect to SQL Server 7sp3 via ADO. I'm using data
> binding to bind a bit column to a check box. The problem is that is
doesn't
> seem to cope with null values. It won't display them, or allow the
checkbox
> to be updated if its a new record with a null value in it. If I
change the
> value in code to 0, all seems to work correctly.
> Is this behaviour 'By Design', or am I using the control incorrectly?
> Ian.
Sent via Deja.com
http://www.deja.com/
