Radicore Forum: How To » Using Created_Date, Revised

Home » RADICORE » How To » Using Created_Date, Revised_Date

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

Re: Using Created_Date, Revised_Date [message #4954 is a reply to message #4953]

Sun, 30 August 2015 05:27

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

Senior Member

(1) On all the tables in the MNU_USER database the user_id column is expected to be VARCHAR(16), so if you wish to populate it with something which looks like a number it will be treated as a string and not a number. This means that in any SQL query the value for user_id must be enclosed in single quotes.

(2) You do NOT have to create those fields with the exact names. I deliberately chose to implement the AUTO_INSERT and AUTO_UPDATE features by using settings in the dictionary and not by the field names.

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

Report message to a moderator

[Message index]

		Using Created_Date, Revised_Date By: melvinsdb on Fri, 07 March 2008 03:45
		Re: Using Created_Date, Revised_Date By: AJM on Fri, 07 March 2008 04:54
		Re: Using Created_Date, Revised_Date By: melvinsdb on Tue, 11 March 2008 21:55
		Re: Using Created_Date, Revised_Date By: AJM on Wed, 12 March 2008 05:38
		Re: Using Created_Date, Revised_Date By: rafs on Sat, 29 August 2015 23:36
		Re: Using Created_Date, Revised_Date By: AJM on Sun, 30 August 2015 05:27
		Re: Using Created_Date, Revised_Date By: rafs on Sun, 30 August 2015 08:16
		Re: Using Created_Date, Revised_Date By: AJM on Mon, 31 August 2015 04:53
		Re: Using Created_Date, Revised_Date By: rafs on Mon, 31 August 2015 11:45

Previous Topic:	Replace detail screen label
Next Topic:	How do I display the "Parent Field" (s) of the linked entities instead of their Primary Keys in a LI

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Jul 26 06:26:43 EDT 2024

Total time taken to generate the page: 0.00970 seconds