Create Timestamp.

[JH10]

Hello
I have a field "mydate" where I wish to record when a record is updated.
This field is a character field

I have looked for instruction how this is done.
I found Steve Woods explanation

its just:

mydate = session.Timestamp
session.Timestamp is a char, so if you want time and date to separate fields:

mydate = ctod(time("MM/dd/yyyy",session.timestamp))
mytime = time("0h:0m:0s",session.timestamp)

But I am not clear where these details are entered.

Can anyone please assist?
Many thanks
John

[cavj1]

Re: Create Timestamp.

What is your database type? I'm using MySql and did this using a trigger.

Thread:
http://msgboard.alphasoftware.com/al...ighlight=mysql

I also found this:
http://msgboard.alphasoftware.com/al...ighlight=mysql

Hope those help
Joe

[Peter.Greulich]

Re: Create Timestamp.

Here's how I do it w. a date. You can do the same for time.

See image....

[JH10]

Re: Create Timestamp.

Thanks for the answers.
I am using ADB.
Peter regarding the Initial value I suspect that will give me the date/time when the record is created.

What I am after doing is to have a field that will give me the date/time when a record is changed/updated. How can I do this please?

[cavj1]

Re: Create Timestamp.

You can use a field rule...on the extended field type set it to calculated and put now() in the calculation field. Just realize that even if you do a mass update/change to the db this will trigger. For some this is an issue for other it is not an issue.

Joe

[Peter.Greulich]

Re: Create Timestamp.

Peter regarding the Initial value I suspect that will give me the date/time when the record is created.

What I am after doing is to have a field that will give me the date/time when a record is changed/updated. How can I do this please?

You are right, John. It will give you the date/time when you save a new record. The easy way is to just create a calc field in your table. It will update each time you save the record. If you run a global operation or some such, you risk "updating" the time stamp when you probably don't want to. The alternative is to use JavaScript or one of the xbasic event handlers in the grid.

[JH10]

Re: Create Timestamp.

Thanks
I have the calculated field update working OK now.
I had a look at which event handler may carry out this operation but could not see which one would do the job.

I thought CanupdateRecord may be the event but

It allows you to abort the update if certain conditions have not been met.

does not sound likely.

Any ideas where I should be looking please?

[chadbrown]

Re: Create Timestamp.

Hi John I think this may help.
If it works it would be the easiest fix for sure.
Keep it simple if you can.

Chad

[JH10]

Re: Create Timestamp.

Thanks Chad
That's an excellent feature.
At the moment I am using ADB as I am using Steve Woods Template and this comes with an adb.
Regards
John

[NicholasWieland]

Re: Create Timestamp.

JOhn,

One other way to do this is to on the grid go to events use the 'AfterUpdateRecords event

put your code in there to do the update

"function AfterUpdateRecords as v (Args as P, PageVariables as P)
with PageVariables
DataSubmitted.Time=now()
end with
end function
DataSubmitted.Fieldname = now()will work here I do have a field named time which really should be named something else but do you use that name......LOL

Or **************************

in A Dialog under form events goto "AfterValidate"
dim tbl as p
tbl = table.open("[PathAlias.ADB_Path]\time_header")
tbl.enter_begin()
tbl.Time = now()
tbl.enter_end()

session.__protected__time = tbl.Id

tbl.close()

Should give a glue for Dialogs and grids.
and I use this for any database connection

[mmaisterrena]

Re: Create Timestamp.

I use Nicolas method as well by setting the time on the CanUpadteRecord grid event:

'----------------------------------
function CanUpdateRecord as v (DataSubmitted as P, Args as p, PageVariables as p, Result as P)
with PageVariables
Result.Cancel = .f.
Result.ErrorHTML = ""

DataSubmitted.mydate = now()

end with
end function
'-------------------------------------

Remember you have to add the mydate field to the grid and make it editable, but the nice thing is that you can hide it in v10 (in v9 hiding it wouldn't work for this)

and it works with any backend DB

[JH10]

Re: Create Timestamp.

Thanks very much Nicholas and mmaisterrena for those extra pointers I will certainly try them out.
Cheers
John