Imran
|
| Posted: 09/06/2002, 8:22 AM |
|
Struggling with some things in CCS as opposed to CC2.
I've got two check boxes. If one checkbox is deselected, I want to make sure
the other one's value is set to be deselected too, before inserting the
record.
I've attempted to do it like this in the before insert event, but it's not
right. Any suggestions would be appreciated.
If Staff.Active.Value = 0 then
Staff.TimeTrack.Value = 0
End If
|
|
|
 |
DonB
|
| Posted: 09/06/2002, 8:43 AM |
|
I suggest using a trigger to enforce this (apparent) business rule in the
database, rather than in the app.
DonB
"Imran" <imranz@knight-images.com> wrote in message
news:alah6o$7ij$1@news.codecharge.com...
> Struggling with some things in CCS as opposed to CC2.
>
> I've got two check boxes. If one checkbox is deselected, I want to make
sure
> the other one's value is set to be deselected too, before inserting the
> record.
>
> I've attempted to do it like this in the before insert event, but it's not
> right. Any suggestions would be appreciated.
>
> If Staff.Active.Value = 0 then
> Staff.TimeTrack.Value = 0
> End If
>
>
>
>
>
>
|
|
|
|
Imran
|
| Posted: 09/06/2002, 8:56 AM |
|
Never mind. I had a total and complete brain fart. I needed it in the Before
Update, not the Before Insert.
"Imran" <imranz@knight-images.com> wrote in message
news:alah6o$7ij$1@news.codecharge.com...
> Struggling with some things in CCS as opposed to CC2.
>
> I've got two check boxes. If one checkbox is deselected, I want to make
sure
> the other one's value is set to be deselected too, before inserting the
> record.
>
> I've attempted to do it like this in the before insert event, but it's not
> right. Any suggestions would be appreciated.
>
> If Staff.Active.Value = 0 then
> Staff.TimeTrack.Value = 0
> End If
>
>
>
>
>
>
|
|
|
|
DonB
|
| Posted: 09/06/2002, 8:59 AM |
|
I hate it when that happens... 
"Imran" <imranz@knight-images.com> wrote in message
news:alaj7b$bjg$1@news.codecharge.com...
> Never mind. I had a total and complete brain fart. I needed it in the
Before
> Update, not the Before Insert.
>
>
>
> "Imran" <imranz@knight-images.com> wrote in message
>news:alah6o$7ij$1@news.codecharge.com...
> > Struggling with some things in CCS as opposed to CC2.
> >
> > I've got two check boxes. If one checkbox is deselected, I want to make
> sure
> > the other one's value is set to be deselected too, before inserting the
> > record.
> >
> > I've attempted to do it like this in the before insert event, but it's
not
> > right. Any suggestions would be appreciated.
> >
> > If Staff.Active.Value = 0 then
> > Staff.TimeTrack.Value = 0
> > End If
> >
> >
> >
> >
> >
> >
>
>
|
|
|
|
|
