Don Oldenburg
|
| Posted: 08/02/2001, 7:21 AM |
|
I have a modified task list from the demo program. I've added a few new
fields. One being "date_last" which is the last time this record has been
modified. I have a "before show update" event which says
flddate_last=now(). The form is properly populated with the correct date
and time. But when I hit update, it doesn't save that back to the database.
Thoughts?
Don
I've also made adjustments to this program to send email to the originator
of the task when the assignee updates it. And also email to the assignee
when he is assigned a new task. Turning into a pretty valuable tool!
|
|
|
|
Alexey Alexapolsky
|
| Posted: 08/02/2001, 7:34 AM |
|
Please use "Before show" event , not "Before show update"
--
Alex
CC
Don Oldenburg <don.oldenburg@cacmnet.com> wrote in message
news:9kbnlf$53j$1@news.codecharge.com...
> I have a modified task list from the demo program. I've added a few new
> fields. One being "date_last" which is the last time this record has been
> modified. I have a "before show update" event which says
> flddate_last=now(). The form is properly populated with the correct date
> and time. But when I hit update, it doesn't save that back to the
database.
>
> Thoughts?
>
> Don
>
> I've also made adjustments to this program to send email to the originator
> of the task when the assignee updates it. And also email to the assignee
> when he is assigned a new task. Turning into a pretty valuable tool!
>
>
>
>
|
|
|
|
Don Oldenburg
|
| Posted: 08/02/2001, 7:51 AM |
|
I moved my code to BEFORE SHOW, and I get the same results. Doesn't work.
Anything else I could try?
"Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
news:9kbocs$6po$1@news.codecharge.com...
> Please use "Before show" event , not "Before show update"
>
> --
> Alex
> CC
>
> Don Oldenburg <don.oldenburg@cacmnet.com> wrote in message
>news:9kbnlf$53j$1@news.codecharge.com...
> > I have a modified task list from the demo program. I've added a few new
> > fields. One being "date_last" which is the last time this record has
been
> > modified. I have a "before show update" event which says
> > flddate_last=now(). The form is properly populated with the correct
date
> > and time. But when I hit update, it doesn't save that back to the
> database.
> >
> > Thoughts?
> >
> > Don
> >
> > I've also made adjustments to this program to send email to the
originator
> > of the task when the assignee updates it. And also email to the
assignee
> > when he is assigned a new task. Turning into a pretty valuable tool!
> >
> >
> >
> >
>
>
|
|
|
|
Chinfei Chuang
|
| Posted: 08/02/2001, 5:24 PM |
|
Don,
I had almost the same question half a month ago. The following was the
answer from CC support and it worked:
Chinfei,
only fields which have of textBox, TextArea, Hidden, ListBox type are
included into insert/update SQL query generated by CodeCharge. What you can
do is add two "written_time" fields on the form. One fields' type set to
Hidden, other to Label (don't forget to change label field name on
field/properties/Common tab in order not to get error of duplicated names).
Then define 'BeforeShow' event to give value to label field and let user see
it on the form and define 'Default Value' for Hidden type field (just put in
textbox):
=date("Y-m-d G:i:s");
Helen D.
Hope this is helpful to you.
Chinfei Chuang
"Don Oldenburg" <don.oldenburg@cacmnet.com> ?????
news:9kbnlf$53j$1@news.codecharge.com...
> I have a modified task list from the demo program. I've added a few new
> fields. One being "date_last" which is the last time this record has been
> modified. I have a "before show update" event which says
> flddate_last=now(). The form is properly populated with the correct date
> and time. But when I hit update, it doesn't save that back to the
database.
>
> Thoughts?
>
> Don
>
> I've also made adjustments to this program to send email to the originator
> of the task when the assignee updates it. And also email to the assignee
> when he is assigned a new task. Turning into a pretty valuable tool!
>
>
>
>
|
|
|
|
|
|
