Update and Added Fields??

Results 1 to 3 of 3

Thread: Update and Added Fields??

  1. #1
    glen Guest

    Default Update and Added Fields??

    How do I create a field that captures the =Now() or at least the date, when a new record is added and then again automatically when updated for an Updated Field. The user wouldn&#039t be able to change these fields.<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Update and Added Fields??

    Generic answer:<BR><BR>&#060;input type="text" readonly value="&#060;%=Now%&#062;"&#062;

  3. #3
    Join Date
    Dec 1969

    Default RE: Update and Added Fields??

    Database Triggers are best known to do these kind of jobs.<BR>Not at all a big thing to learn.You yourself can write very easily for various events like after/before insert,update and delete.I think almost all the DB support them.<BR><BR>Regarding the Non-updatability of these fields, wherever you display them, just display them on the browser.(I mean don&#039t display them in any textboxes etc..)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts