devxlogo

Record date/time when updating record

Record date/time when updating record

Question:
I’m using PB6.0 with Sybase SQL Anywhere 5.0. I would like to be able to record the date and time in my table(s) whenever a user updates or adds a row. Any suggestions on the best way to do it?

I’ve tried using the TIMESTAMP data type, but have read (and been told) that this is a binary value that is not user readable. I may want to sort on these columns so I would rather use a datetime type.

My problem with the datetime type is that when I define it within SQL Anywhere (using Sybase Central) and then look at the data definition within Powerbuilders’ database painter, the column that’s been defined as a datetime type turns into a timestamp. What’s the best way to insure that I have an accurate date and timestamp within each table?

Answer:
The best way to do it is with a Trigger on the database. Then reread the record back to the clinet.

See also  How HealthStream Learning Center Supports Healthcare Education and Compliance
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist