CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> CodeChargeStudio.Discussion

 Pre Save and Update

Print topic Send  topic

Author Message
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.
> > >
> > >
> >
> >
>
>


   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.