Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: PowerBuilder
Expertise: Beginner
Jun 26, 1998

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.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date