| 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: 2386 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
		
 |  
	| 
		
	 | 
 
 
 | 
	| 
		
 | 
	| 
		
 |