Frank Rocco
|
| Posted: 08/21/2001, 6:29 AM |
|
Hello,
In the "Before Show Update" event, I save the current values:
xAssigned_to = getValue(rs,"assigned_to")
xStatus_id = getValue(rs,"status_id")
In the "Before Update" event I want to compare for changes, but it is not
working. Assigned to is always getting written.
if Cint(xassigned_to) <> Cint(fldassigned_to) then
sAssigned_to = DLookUp("employees", "employee_name", "employee_id =" &
fldAssigned_to)
fldresolution = Trim(fldresolution) & chr(13) & chr(13) & date() & " " &
Time() & " " & sUser & chr(13) & _
"Assigned to changed to " & sAssigned_to
end if
Thanks for th help.
Frank
|
|
|
 |
CodeCharge
|
| Posted: 08/21/2001, 12:05 PM |
|
You wrote that "Assigned to is always getting written."
Shouldn't it ?
"Frank Rocco" <farocco@hotmail.com> wrote in message
news:9ltnod$ti2$1@news.codecharge.com...
> Hello,
>
> In the "Before Show Update" event, I save the current values:
> xAssigned_to = getValue(rs,"assigned_to")
> xStatus_id = getValue(rs,"status_id")
>
> In the "Before Update" event I want to compare for changes, but it is not
> working. Assigned to is always getting written.
>
> if Cint(xassigned_to) <> Cint(fldassigned_to) then
> sAssigned_to = DLookUp("employees", "employee_name", "employee_id =" &
> fldAssigned_to)
> fldresolution = Trim(fldresolution) & chr(13) & chr(13) & date() & " " &
> Time() & " " & sUser & chr(13) & _
> "Assigned to changed to " & sAssigned_to
> end if
>
>
> Thanks for th help.
> Frank
>
>
|
|
|
|
Frank Rocco
|
| Posted: 08/21/2001, 1:45 PM |
|
>> if Cint(xassigned_to) <> Cint(fldassigned_to) then<<
The line above is always getting executed. The user has not changed the
fldassigned_to list. Why is it thinking it is changed?
Thanks
Frank
|
|
|
|
CodeCharge
|
| Posted: 08/21/2001, 5:42 PM |
|
Maybe you could try putting saving variables in Open Event:
xAssigned_to = getValue(rs,"assigned_to")
xStatus_id = getValue(rs,"status_id")
"CodeCharge" <support@codecharge.com> wrote in message
news:9lubct$1ni$1@news.codecharge.com...
> You wrote that "Assigned to is always getting written."
> Shouldn't it ?
>
> "Frank Rocco" <farocco@hotmail.com> wrote in message
>news:9ltnod$ti2$1@news.codecharge.com...
> > Hello,
> >
> > In the "Before Show Update" event, I save the current values:
> > xAssigned_to = getValue(rs,"assigned_to")
> > xStatus_id = getValue(rs,"status_id")
> >
> > In the "Before Update" event I want to compare for changes, but it is
not
> > working. Assigned to is always getting written.
> >
> > if Cint(xassigned_to) <> Cint(fldassigned_to) then
> > sAssigned_to = DLookUp("employees", "employee_name", "employee_id =" &
> > fldAssigned_to)
> > fldresolution = Trim(fldresolution) & chr(13) & chr(13) & date() & " "
&
> > Time() & " " & sUser & chr(13) & _
> > "Assigned to changed to " & sAssigned_to
> > end if
> >
> >
> > Thanks for th help.
> > Frank
> >
> >
>
>
|
|
|
|
|
