I have installed a table editor, (Universal Table Editor) which is coded by classic asp. However I am not able to edit or delete a column. I recieve the error
Invalid column name 'False'
The reasons seems to be bit field of SQL Server, it displays true/false but it is not a boolean field.
So is there a way to solve it in SQL Server?, or is there an easy solution on ASP code? (I saw a solution for adding a parameter booleanasbit = true, but couldn't implement it)
When setting a BIT field, use 0 for 'False' and 1 for 'True'.
Note that there are no quotes around the 0 or 1.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With