Your full service technology partner! 
-Collapse +Expand
Search Paradox Group:

-Collapse +Expand Paradox To/From
-Collapse +Expand Paradox Store

Prestwood eMagazine

May Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyCorel Paradox / ObjectPAL Coding BoardObjectPAL Topic   Print This     

Best place to put code to update timestamp (form)

Best place to put code to update timestamp (form) in ObjectPAL topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: timestamp   Best place   Best place put   code update   timestamp (form)  
New York, NY USA

I want to have a modified timestamp that gets updated every time a record gets changed.  I do have a timestamp field, and the default value is NOW.  However, this only sets a date and time on initial record creation.   Thus it appears that in order to update the timestamp I should do it via code just prior to the record being posted.  What is the best location for this?  In the forms Action method?  Which event should I be looking for?  Thanks.

 Posted 7 years ago (Thread Starter)
Comment Quote
About Joe.P -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #14729, 1 reply
Thread Started 12/3/2011 9:48:35 AM
View Counter=1712
Location=New York, NY USA 
Joined=7 years ago   MB Posts=3  
Most Recent Post
Daniel Fought
Prestwood IT
Home office in Fresno, CA.

Your right on the location.  Trap for the DataPostRecord and athe DataUnlockRecord event, then set the value of the timestamp field.

Dan Fought
Senior Programmer Analyst
Prestwood IT Solutions

 Posted 7 years ago
Comment Quote
About Daniel Fought -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About Daniel Fought
Danial Fought is a senior programmer analyst with Prestwood IT where he develops custom Windows software and custom websites. When Dan is not coding for clients, he participates in this online community. Coding specialties include Paradox/ObjectPAL, MS Access, Visual Basic, and VS.Net/VB.Net.

Post ID #14730 (Level 2) and Parent is 14729
Reply Posted 12/3/2011 2:26:32 PM
Location=Home office in Fresno, CA. 
Joined=16 years ago   MB Posts=401   KB Posts=12   KB Comments=4  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.

Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1256A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #14729 Counter
Since 12/3/2011
   Contact Us!
Have a question? Need our services? Contact us now.
--Mike Prestwood

Call: 916-726-5675


Go ahead!   Use Us! Call: 916-726-5675 

©1995-2018 Prestwood IT Solutions.   [Security & Privacy]