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
|
|
|
Re: Auto populate dict columns [message #2354 is a reply to message #2353] |
Sat, 07 November 2009 13:17 |
AJM
Messages: 2368 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
|
|
|
|
|