CodeCharge Studio
search Register Login  

Web Reports

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

YesSoftware Forums -> Archive -> CodeChargeStudio.Discussion

 After insert code to manage inventory

Print topic Send  topic

Author Message
Charles
Posted: 12/13/2003, 6:56 PM

Hi All,
I am trying to write an after insert event code to manage inventory of items
in my products table.
All i want is for the quantity on hand column in the products table to be
updated when an item is ordered in the items_orders table.How do i go about
this?
regards,
charles

Trisiana
Posted: 12/18/2003, 2:22 AM

I suggest you use insert trigger in your database back-end... I think that's
the most simple & reliable method in your case.
What kind of database you use?

"Charles" <ronicsyscom@ronicsystems.com> wrote in message
news:brgjgb$ntn$1@news.codecharge.com...
> Hi All,
> I am trying to write an after insert event code to manage inventory of
items
> in my products table.
> All i want is for the quantity on hand column in the products table to be
> updated when an item is ordered in the items_orders table.How do i go
about
> this?
> regards,
> charles
>
>

Charles
Posted: 12/18/2003, 7:33 PM

Hi ,
Thanks for your response.I use MS SQL but intend to also have the app
working with an access database, hence my reluctance to go the "trigger"
way.Is there a way to use trigger in access also?
Regards,
Charles
"Trisiana" <trisiana.tana@lycos.co.uk> wrote in message
news:brrv56$q9t$1@news.codecharge.com...
> I suggest you use insert trigger in your database back-end... I think
that's
> the most simple & reliable method in your case.
> What kind of database you use?
>
> "Charles" <ronicsyscom@ronicsystems.com> wrote in message
>news:brgjgb$ntn$1@news.codecharge.com...
> > Hi All,
> > I am trying to write an after insert event code to manage inventory of
> items
> > in my products table.
> > All i want is for the quantity on hand column in the products table to
be
> > updated when an item is ordered in the items_orders table.How do i go
> about
> > this?
> > regards,
> > charles
> >
> >
>
>


   


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

PHP Reports

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

Home   |    Search   |    Members   |    Register   |    Login


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