// Changing data type to Boolean - SQL //

[Lemoex]

Can anyone tell me how they changed the datatype in SQL. I've looked everywhere and I can't change it from INT to BOOLEAN.

Error:

StartTimer exception: Cannot access field 'FLD_ANTIPUSH' as type Boolean


Thanks,

Lemoex

 

[boothy]

I think you need to change it to Data type: bit

 

[Lemoex]

Aaa right, thanks for the advice, but do you know how to change it to BIT? lol

 

[boothy]

Just go into SQL, TBL_MONSTER design table, find FLD_ANTIPUSH and write " bit " in the DataType column. Or just select it from the dropdown menu

 

[Lemoex]

I've looked and honestly can't find anywhere with a drop down list or anywhere to write.

You mean the place where it says <NULL> - that's the only place that I can find where your able to edit it o__O

http://tinypic.com/view.php?pic=30wqosk&s=4

If you mean there, I can't edit anything. No right click/dropdown lists

 

[boothy]

Right click TBL_MONSTER then click Design Table, then u'll be able to edit the DataType column

 

[Lemoex]

Ooo thanks alot mate, really appreciate it ^^

 

[Lemoex]

Edit// - Moved to more appropriate thread