Invalid use of Null: 'CBool'

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   I'd rather run a script if possible, to set all values to 'True'.

Could you advise on what SQL query would I need to run to update them?

I thought it would be the following;

UPDATE tblThread set Show_signature = True

But my host is coming back with a message, saying that the above throws up the following error;

Server: Msg 207, Level 16, State 3, Line 1

Invalid column name 'True'.