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.

Insert Trigger

2 posts in General Discussion Last posting was on 2004-03-23 17:22:44.0Z
PM Posted on 2004-03-23 17:07:59.0Z
Sender: 3758.40606ea1.1804289383@sybase.com
From: PM
Newsgroups: ianywhere.public.general
Subject: Insert Trigger
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <40606eef.375f.846930886@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 23 Mar 2004 09:07:59 -0800
X-Trace: forums-1-dub 1080061679 10.22.241.41 (23 Mar 2004 09:07:59 -0800)
X-Original-Trace: 23 Mar 2004 09:07:59 -0800, 10.22.241.41
Lines: 6
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2820
Article PK: 6291

How do I create a trigger that upon insert if column A is
null
will update column a with the inserting value of column B
which happens to be the primary key.

Thanks


Reg Domaratzki Posted on 2004-03-23 17:22:44.0Z
From: "Reg Domaratzki" <Spam_bad_rdomarat@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <40606eef.375f.846930886@sybase.com>
Subject: Re: Insert Trigger
Lines: 22
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Original-NNTP-Posting-Host: rdomarat-pc.sybase.com
Message-ID: <40607260@forums-2-dub>
X-Original-Trace: 23 Mar 2004 09:22:40 -0800, rdomarat-pc.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 23 Mar 2004 09:22:41 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 23 Mar 2004 09:22:44 -0800
X-Trace: forums-1-dub 1080062564 10.22.108.75 (23 Mar 2004 09:22:44 -0800)
X-Original-Trace: 23 Mar 2004 09:22:44 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2821
Article PK: 6290

Please don't cross-post. I posted a sample on the thread you created in the
sybase.public.sqlanywhere.general newsgroup.

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL

<PM> wrote in message news:40606eef.375f.846930886@sybase.com...
> How do I create a trigger that upon insert if column A is
> null
> will update column a with the inserting value of column B
> which happens to be the primary key.
>
> Thanks