Monday, March 12, 2012

save boolean values in a sql2000 table

I try to insert VB.NET boolean true values into a SQL2000 table thru a stored procedure. While varchar fields of the table are correctly filled, I'm surprised to find the bit fields all stay 0 after every single insert. This makes me wonder if VB.NET boolean variables can be passed to sp bit parameters and inserted into a SQL2000 table. Or did I miss something? Please advise. Thanks.Oop! I found a bug in the GUI that captures the input. It's fixed and now works fine. Thanks.

No comments:

Post a Comment