Hi,
I've come across a problem when adding an INT field. Here are the steps:
1) Goto the table, click "Add Column"
2) Add the field as: Field_Name / INT / NOT NULL / default: 0
3) This gives an error about the value not being able to be empty.
If you set the default as 1, then go in and edit the default to 0 after adding the field - it works fine .
I thought it was just me being silly - but I've done more testing, and that is definatly the case.
TIA
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
I've come across a problem when adding an INT field. Here are the steps:
1) Goto the table, click "Add Column"
2) Add the field as: Field_Name / INT / NOT NULL / default: 0
3) This gives an error about the value not being able to be empty.
If you set the default as 1, then go in and edit the default to 0 after adding the field - it works fine .
I thought it was just me being silly - but I've done more testing, and that is definatly the case.
TIA
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!