Ask Your Question

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

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

anonymous user


updated 2020-08-09 00:30:33 +0200

Alex Kemp gravatar image

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

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

mahfiaz gravatar image
edit flag offensive delete link more


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:

If you use MySQL as backend:

Not sure about the integrated database.

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

Question Tools


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

Seen: 526 times

Last updated: May 07 '12