Ask Your Question
0

How to update a DATETIME field when a checkbox is clicked? [closed]

asked 2012-05-06 01:56:59 +0200

anonymous user

Anonymous

For my Tasks, I have a CompletedDate field and a Completed? field represented by a checkbox on the form. I want to set the Completeddate to the current date when the checkbox is clicked.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-16 00:24:23.446529

1 Answer

Sort by » oldest newest most voted
1

answered 2012-05-07 22:08:36 +0200

mahfiaz gravatar image
edit flag offensive delete link more

Comments

Thanks, will look into it. As i was searching, I learned a little about database triggers. Does LO Base support them?

Jim gravatar imageJim ( 2012-05-10 23:49:19 +0200 )edit

If you use HSQLDB as backend: http://user.services.openoffice.org/en/forum/viewtopic.php?t=25965

If you use MySQL as backend: http://dev.mysql.com/doc/refman/5.0/en/triggers.html

Not sure about the integrated database.

mahfiaz gravatar imagemahfiaz ( 2012-05-11 16:39:29 +0200 )edit

Question Tools

Stats

Asked: 2012-05-06 01:56:59 +0200

Seen: 450 times

Last updated: May 07 '12