Bon733
|
Posted: 09/04/2003, 10:16 AM |
|
I currently have four fields that track the date and user that added a
record and the date and user that last modified the record. At what point
should I place the code to update these fields? (i.e. Before Insert Event,
Before Execute Insert Event, etc..)
Thanks.
|
|
|
DonB
|
Posted: 09/04/2003, 12:51 PM |
|
At least with ASP, these events are equivalent - they are "adjacent" in the
flow of the code. It may matter with other environments but with ASP it
makes no difference whatsoever which event you use.
--
DonB
http://www.gotodon.com/ccbth
"Bon733" <bon@nospam.com> wrote in message
news:bj7s1j$3it$1@news.codecharge.com...
> I currently have four fields that track the date and user that added a
> record and the date and user that last modified the record. At what point
> should I place the code to update these fields? (i.e. Before Insert Event,
> Before Execute Insert Event, etc..)
>
> Thanks.
>
>
|
|
|
Bon733
|
Posted: 09/04/2003, 1:32 PM |
|
Thanks. I am using ASP and I'm just to avoid double update statements, or
errors stating that the record has already been updated.
Would you know if CCS has an object or type library? This way I would not
have to cust/paste the code in each form.
"DonB" <~ccbth~@gotodon.com> wrote in message
news:bj854l$fop$1@news.codecharge.com...
> At least with ASP, these events are equivalent - they are "adjacent" in
the
> flow of the code. It may matter with other environments but with ASP it
> makes no difference whatsoever which event you use.
>
> --
> DonB
>
> http://www.gotodon.com/ccbth
>
>
> "Bon733" <bon@nospam.com> wrote in message
>news:bj7s1j$3it$1@news.codecharge.com...
> > I currently have four fields that track the date and user that added a
> > record and the date and user that last modified the record. At what
point
> > should I place the code to update these fields? (i.e. Before Insert
Event,
> > Before Execute Insert Event, etc..)
> >
> > Thanks.
> >
> >
>
>
|
|
|
DonB
|
Posted: 09/04/2003, 4:57 PM |
|
CCS just outputs straight ASP code - there are no typlibs to mess with..
You can minimize the cutting and pasting by putting chunks of code into
#INCLUDE files, inside the <%..%> brackets of each ASP file where you need
it - just be sure to put the include outside the "gray" sections of code
which CCS controls.
You would be wise (my opinion) to put frequently-used functionality into
class modules and instantiate objects to do those functions wherever needed.
--
DonB
http://www.gotodon.com/ccbth
"Bon733" <bon@nospam.com> wrote in message
news:bj87gv$in2$1@news.codecharge.com...
> Thanks. I am using ASP and I'm just to avoid double update statements, or
> errors stating that the record has already been updated.
>
> Would you know if CCS has an object or type library? This way I would not
> have to cust/paste the code in each form.
>
>
> "DonB" <~ccbth~@gotodon.com> wrote in message
>news:bj854l$fop$1@news.codecharge.com...
> > At least with ASP, these events are equivalent - they are "adjacent" in
> the
> > flow of the code. It may matter with other environments but with ASP it
> > makes no difference whatsoever which event you use.
> >
> > --
> > DonB
> >
> > http://www.gotodon.com/ccbth
> >
> >
> > "Bon733" <bon@nospam.com> wrote in message
> >news:bj7s1j$3it$1@news.codecharge.com...
> > > I currently have four fields that track the date and user that added a
> > > record and the date and user that last modified the record. At what
> point
> > > should I place the code to update these fields? (i.e. Before Insert
> Event,
> > > Before Execute Insert Event, etc..)
> > >
> > > Thanks.
> > >
> > >
> >
> >
>
>
|
|
|
|