Radicore Forum: How To » Using a function in a primary key field

Home » RADICORE » How To » Using a function in a primary key field

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

Re: Using a function in a primary key field [message #4985 is a reply to message #4973]

Wed, 02 September 2015 12:12

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

Senior Member

That is correct. If you set the value of a field to a function as in "now()" then the value from that function will not be known until the query is executed. You cannot use functions for unique keys as RADICORE will test for uniqueness before the query is executed.

You should remove "now()" from the default value in the Data Dictionary and set the "Auto Insert" property instead. This will allow the framework to obtain the correct value before the test for uniqueness is performed.

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

Report message to a moderator

[Message index]

		Using a function in a primary key field By: rafs on Wed, 02 September 2015 01:50
		Re: Using a function in a primary key field By: AJM on Wed, 02 September 2015 12:12

Previous Topic:	Cancel a Generate PHP screen
Next Topic:	Open a new window from RADICORE

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Apr 28 00:07:06 EDT 2024

Total time taken to generate the page: 0.00922 seconds