Radicore Forum: RADICORE Suggestions » Auto populate dict columns

Home » RADICORE » RADICORE Suggestions » Auto populate dict columns

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

Auto populate dict columns [message #2353]

Sat, 07 November 2009 12:44

ljkbrost
Messages: 59
Registered: April 2006

Member

Hi,

It would be nice if the system could automatically create the correct column settings for those columns with special meaning within in the system.

For example if a table has created_date, created_user, revised_date, or revised_user, the defaults would be applied to the column. Particularily the nosearch, noedit, and auto update options.

This would save a bunch of click when setting up new tables.

Cheers,

Kyle Brost
----
www.softelephant.com

Report message to a moderator

Re: Auto populate dict columns [message #2354 is a reply to message #2353]

Sat, 07 November 2009 13:17

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

Senior Member

I cannot guarantee that you will use exactly the same field names as those, so I don't default any properties based on field names.

When I create new tables containing those fields I use my database admin tool (usually phpMyAdmin) to run script radicore\dict\sql\update_created_date.sql which sets these properties automatically.

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

Report message to a moderator

Re: Auto populate dict columns [message #2355 is a reply to message #2354]

Sat, 07 November 2009 13:46

ljkbrost
Messages: 59
Registered: April 2006

Member

That's a helpful script!

But... Don't you have the name the fields exactly as you for the framework to do the work? I can't change created_user to created_uid.

Report message to a moderator

Re: Auto populate dict columns [message #2356 is a reply to message #2355]

Sat, 07 November 2009 15:47

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

Senior Member

You can call the fields whatever you like. It's the properties that you give the field that tells the framework what to do with it, not the name.

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

Report message to a moderator

Previous Topic:	Anonymous browsing
Next Topic:	MYSQL Configuration Options

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Jul 06 13:40:57 EDT 2025

Total time taken to generate the page: 0.09934 seconds