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.

update one table into another

2 posts in General Discussion Last posting was on 2002-09-06 16:01:26.0Z
Pastor Posted on 2002-09-06 08:51:22.0Z
Reply-To: "Pastor" <snepak@sojanet.co.yu>
From: "Pastor" <snepak@eunet.co.yu>
Subject: update one table into another
Date: Fri, 6 Sep 2002 10:51:22 +0200
Lines: 5
Organization: becejka
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <7Rz3jWYVCHA.285@forums.sybase.com>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: P-6.144.EUnet.yu 213.240.6.144
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:636
Article PK: 2655

I have one problem. I want that every time when somebody change data in -
table "one" add,change or delete all data be copy (update) into another
table - table "two".


Robert Waywell Posted on 2002-09-06 16:01:26.0Z
From: "Robert Waywell" <rwaywell@ianywhere.com>
References: <7Rz3jWYVCHA.285@forums.sybase.com>
Subject: Re: update one table into another
Date: Fri, 6 Sep 2002 12:01:26 -0400
Lines: 32
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Message-ID: <B2LdLCcVCHA.295@forums.sybase.com>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: 172.31.143.74
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:630
Article PK: 3172

Sounds like a row level trigger to me.

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

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

"Pastor" <snepak@eunet.co.yu> wrote in message
news:7Rz3jWYVCHA.285@forums.sybase.com...
> I have one problem. I want that every time when somebody change data in -
> table "one" add,change or delete all data be copy (update) into another
> table - table "two".
>
>