Okay here is my situation (not sure if this is a VB problem or SQL)
Anyway I have a form that I use to connect and update records on a SQL 2000 database.
I have set certain columns in the table to have a default value of FALSE.
If I use my SQL console I can add records and the default values get put int eh columns like I want.
However if I try to add a record through my app, the default values get set to NULL and not to FALSE like I want them to. The record gets added and even adds the information except for those default values being set to NULL.
Anyone have any ideas? TIA.
Anyway I have a form that I use to connect and update records on a SQL 2000 database.
I have set certain columns in the table to have a default value of FALSE.
If I use my SQL console I can add records and the default values get put int eh columns like I want.
However if I try to add a record through my app, the default values get set to NULL and not to FALSE like I want them to. The record gets added and even adds the information except for those default values being set to NULL.
Anyone have any ideas? TIA.