Radicore Forum: How To » setting default values for created_date and updated

Home » RADICORE » How To » setting default values for created_date and updated_date (RADICORE doesn't seem to like it when you do this...)

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

Re: setting default values for created_date and updated_date [message #4983 is a reply to message #4972]

Wed, 02 September 2015 11:30

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

Senior Member

Firstly, the correct value for that default would be "now()" as any word followed by "(...)" is treated as a function. 'now' in quotes is treated as a string and is totally invalid for a field which is supposed to hold a timestamp.

Secondly, you should remove "now()" from the default value in the Data Dictionary and set the "Auto Insert" property instead.

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

Report message to a moderator

[Message index]

		setting default values for created_date and updated_date By: rafs on Wed, 02 September 2015 01:24
		Re: setting default values for created_date and updated_date By: AJM on Wed, 02 September 2015 11:30

Previous Topic:	Setting PK field to NOEDIT, but not NOSEARCH
Next Topic:	Cancel a Generate PHP screen

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Nov 22 14:13:24 EST 2024

Total time taken to generate the page: 0.01016 seconds