Radicore Forum: Application Development

Home » RADICORE development » Application Development » Bug???

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Bug??? [message #2203]

Fri, 10 July 2009 17:41

edortizq
Messages: 82
Registered: August 2008
Location: Ecuador

Member

I have a table in a mysql database, this table has an integer field wich allows NULL values, when I update this field with 0 (zero) value it takes the NULL value instead of Zero, with this behavior the dropdown list wich works with this field, shows nothing instead of the item associated with the zero value.
I'm solving the problem defining the fields as NOT NULL WITH DEFAULT; but it doesn't seem a real solution for me.
Please your suggestions or comments.

Report message to a moderator

Re: Bug??? [message #2204 is a reply to message #2203]

Sat, 11 July 2009 05:20

AJM
Messages: 2371
Registered: April 2006
Location: Surrey, UK

Senior Member

What version of Radicore are you using? I have just tried the 'Update Person' task in my demonstration system as it has a nullable integer field called 'value1'. When I enter '0' it is stored in the database as '0' and shows up as '0' when I return to the screen. If I change it to '' it is stored as NULL and shows up as empty. I cannot see a bug here.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: Bug??? [message #2205 is a reply to message #2204]

Sat, 11 July 2009 19:14

edortizq
Messages: 82
Registered: August 2008
Location: Ecuador

Member

Thanks for your answer. The version seems to be 1.37.0 released 2008-07-01

Report message to a moderator

Previous Topic:	Performance problem
Next Topic:	USER Management

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue Dec 03 14:23:07 EST 2024

Total time taken to generate the page: 0.01430 seconds