One problem with this procedure is that when you unload and load
a table you will lose all those calculated dates and times because they
will be replaced by the date and time of the load.
One approach we used was to have two separate columns, a date entered
and a dated updated. We also recorded the personNumber of the user
when the original entry or change was made. An insert command or a
form variable put the current date in the column for date updated if the
current date differs from the date of entry:
dateUpdated = (IFEQ(DateEntered,.#DATE, NULL, .#Date))
Randy Peterson
Troy Sosamon wrote:
> An easy way to do it is to put 2 computed columns on the table, one with a
> date = .#date the other w/ time = .#time. This will update anytime the row is
> changed.
>
> Troy
>
> >===== Original Message From [EMAIL PROTECTED] =====
> >I need to place a DateTime stamp in a column when a row has been updated.
> >
> >Seems simple enough until you consider the following:
> >
> >Lets say the user accesses a Customer/Transaction form
> >(with the transactions being defined as a region)
> >
> >Initially, the focus is on the transactions.
> >If they click back to the top (Customer Side) and make a change
> >how can I detect a change to that specific table and update the
> >DateTime stamp?
> >
> >I've experimented with the following technics without success:
> >
> >- Triggers (too constrictive in forms with regions)
> >- Variables in Form (get evaluated regardless of change to data)
> >- Using an EEP on Entry/Exit to table <or> after Leaving Section
> > (Form_Dirty_Flag detects changes made to ANY table)
> >
> >Recommendations Anyone?
> >
> >TIA
> >
> >- Rob Vincent
>
> Troy Sosamon
> Denver Co
> [EMAIL PROTECTED]
>
> ================================================
> TO SEE MESSAGE POSTING GUIDELINES:
> Send a plain text email to [EMAIL PROTECTED]
> In the message body, put just two words: INTRO rbase-l
> ================================================
> TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
> In the message body, put just two words: UNSUBSCRIBE rbase-l
> ================================================
> TO SEARCH ARCHIVES:
> http://www.mail-archive.com/rbase-l%40sonetmail.com/
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
