Date/Time stamp in database

R

Rick

Is there a way to automatically update a date/time field
in a database when a record in the database is updated?
 
C

clintonG

Since you know you want to update the date and time you include
the date time field as one field included with the retrieval of
others when you create the record set. Then update the date time
field in the record set before saving the modified record set back
to the database for updating which enables you to reduce the number
of operations while achieving the same objective.

If you want the date time on the server you can be better off using
SQL to modify the date time field data before it is returned to the
SELECT query [1].

If you want the date time on the client you'll use JavaScript to query
the client's machine [2].

--
<%= Clinton Gallagher, "Twice the Results -- Half the Cost"
Architectural & e-Business Consulting -- Software Development
NET (e-mail address removed)
URL http://www.metromilwaukee.com/clintongallagher/

[1]
http://www.amazon.com/exec/obidos/A...24859/sr=ka-2/ref=pd_ka_2/104-7706747-0956731
[2] http://developer.irt.org/script/script.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top