Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

trigger

2 posts in General Discussion Last posting was on 2003-10-30 15:51:21.0Z
digger Posted on 2003-10-29 14:25:01.0Z
From: "digger" <neltro@bigfoot.com>
Newsgroups: ianywhere.public.general
Subject: trigger
Lines: 29
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.3790.0
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
X-Original-NNTP-Posting-Host: 202.74.0.2
Message-ID: <3f9fdcdf@forums-2-dub>
X-Original-Trace: 29 Oct 2003 07:29:35 -0700, 202.74.0.2
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 29 Oct 2003 07:17:20 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 29 Oct 2003 07:25:01 -0700
X-Trace: forums-1-dub 1067441101 10.22.108.75 (29 Oct 2003 07:25:01 -0700)
X-Original-Trace: 29 Oct 2003 07:25:01 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1948
Article PK: 4185

Hi all,

header table

id.............1
cur...........usd
rate..........1.2345



detail table

id.............1
item..........001
qty............5
price.........15
amt...........75


-----------------------------------
now i want to make a trigger to update the price and amt based on the rate
in the header each time the detail/header is updated.

how can i do that?


thanks is adv.


Stephen Rice Posted on 2003-10-30 15:51:21.0Z
Newsgroups: ianywhere.public.general
Subject: Re: trigger
From: Stephen Rice <srice_nospam@ianywhere.com>
References: <3f9fdcdf@forums-2-dub>
Organization: iAnywhere Solutions
Message-ID: <Xns9424774D4F311sricenospamianywhere@10.22.241.106>
User-Agent: Xnews/5.04.25
NNTP-Posting-Host: srice-pc.sybase.com
X-Original-NNTP-Posting-Host: srice-pc.sybase.com
Date: 30 Oct 2003 08:51:21 -0700
X-Trace: forums-1-dub 1067532681 172.31.141.106 (30 Oct 2003 08:51:21 -0700)
X-Original-Trace: 30 Oct 2003 08:51:21 -0700, srice-pc.sybase.com
Lines: 54
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1972
Article PK: 17399


"digger" <neltro@bigfoot.com> wrote in news:3f9fdcdf@forums-2-dub:

> Hi all,
>
> header table
>
> id.............1
> cur...........usd
> rate..........1.2345
>
>
>
> detail table
>
> id.............1
> item..........001
> qty............5
> price.........15
> amt...........75
>
>
> -----------------------------------
> now i want to make a trigger to update the price and amt based on the
> rate in the header each time the detail/header is updated.
>
> how can i do that?
>
>
> thanks is adv.
>
>
>

I'm not sure exactly what you are asking so I need a bit more
information.

When you update header_table what do you want to happen? This goes in
an update trigger created on header_table.

When you update detail_table what do you want to happen? This goes in
an update trigger created on detail_table.

/steve

--
Stephen Rice
Technical Services Manager
iAnywhere Solutions

- Please Post-
Whitepapers, TechDocs, and bug fixes are all available through the
iAnywhere
Developer Community at www.ianywhere.com/developer