Hidden Default Values

This sample demonstrates how on each insert or update of a row, some fields can be filled in programatically without letting the user modify this fields.

In this demo, we use the 'Title' column to store the user who created a new employee record, and when. The 'Notes' column is used to log who updated the record, and when. The user cannot edit any of this information his or herself.

Search:  
 EmployeeIDLastNameFirstNameTitleBirthDateHireDateNotes
Edit1DavolioNancySales Representative12/8/1948 12:00:00 AM5/1/1992 12:00:00 AMEducation includes a BA in psychology from Colorado State University in 1970. She also completed "The Art of the Cold Call." Nancy is a member of Toastmasters International.
Edit2FullerAndrewVice President, Sales2/19/1952 12:00:00 AM8/14/1992 12:00:00 AMAndrew received his BTS commercial in 1974 and a Ph.D. in international marketing from the University of Dallas in 1981. He is fluent in French and Italian and reads German. He joined the company as a sales representative, was promoted to sales manager in January 1992 and to vice president of sales in March 1993. Andrew is a member of the Sales Management Roundtable, the Seattle Chamber of Commerce, and the Pacific Rim Importers Association.
Edit3LeverlingJanetSales Representative8/30/1963 12:00:00 AM4/1/1992 12:00:00 AMJanet has a BS degree in chemistry from Boston College (1984). She has also completed a certificate program in food retailing management. Janet was hired as a sales associate in 1991 and promoted to sales representative in February 1992.
Edit4PeacockMargaretSales Representative9/19/1937 12:00:00 AM5/3/1993 12:00:00 AMMargaret holds a BA in English literature from Concordia College (1958) and an MA from the American Institute of Culinary Arts (1966). She was assigned to the London office temporarily from July through November 1992.
Edit5BuchananStevenSales Manager3/4/1955 12:00:00 AM10/17/1993 12:00:00 AMSteven Buchanan graduated from St. Andrews University, Scotland, with a BSC degree in 1976. Upon joining the company as a sales representative in 1992, he spent 6 months in an orientation program at the Seattle office and then returned to his permanent post in London. He was promoted to sales manager in March 1993. Mr. Buchanan has completed the courses "Successful Telemarketing" and "International Sales Management." He is fluent in French.
Page: 1 2 Next