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.

cascade delete when download delete from mobilink server?

2 posts in General Discussion Last posting was on 2008-06-25 21:22:35.0Z
gpzhang Posted on 2008-06-25 05:17:20.0Z
From: "gpzhang" <gpzhang@sybase.com>
Newsgroups: ianywhere.public.general
Subject: cascade delete when download delete from mobilink server?
Lines: 17
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4861d4e0@forums-1-dub>
Date: 24 Jun 2008 22:17:20 -0700
X-Trace: forums-1-dub 1214371040 10.22.241.152 (24 Jun 2008 22:17:20 -0700)
X-Original-Trace: 24 Jun 2008 22:17:20 -0700, vip152.sybase.com
X-Authenticated-User: pbplugin
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6932
Article PK: 5158

Hi,

I want to do following:

When download delete table A action from mobilink server, to delete from
table A, I want to also delete from table B, but table A is in subscription
while table B is not synchronizable.

I tried to add a foreign key in table B which reference table A and hope
table B's data can be deleted cascaded. But Sql Anywhere reports error about
integrity.

Is there any way to achieve?

Thanks,


David Fishburn Posted on 2008-06-25 21:22:35.0Z
Newsgroups: ianywhere.public.general
Subject: Re: cascade delete when download delete from mobilink server?
From: David Fishburn <fishburn_spam_off@ianywhere.com>
References: <4861d4e0@forums-1-dub>
Organization: iAnywhere Solutions
Message-ID: <Xns9AC8B0BF45D18fishburnsybasecom@192.138.151.106>
User-Agent: Xnews/2005.10.18
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 25 Jun 2008 14:22:35 -0700
X-Trace: forums-1-dub 1214428955 10.22.241.152 (25 Jun 2008 14:22:35 -0700)
X-Original-Trace: 25 Jun 2008 14:22:35 -0700, vip152.sybase.com
Lines: 43
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6933
Article PK: 5160

"gpzhang" <gpzhang@sybase.com> wrote in news:4861d4e0@forums-1-dub of
ianywhere.public.general:

g> I want to do following:
g>
g> When download delete table A action from mobilink server, to delete
g> from table A, I want to also delete from table B, but table A is in
g> subscription while table B is not synchronizable.
g>
g> I tried to add a foreign key in table B which reference table A and
g> hope table B's data can be deleted cascaded. But Sql Anywhere reports
g> error about integrity.

Please ALWAYS include version and MORE importantly BUILD number
with EACH post (dbeng10 -v).

Hard to say without seeing how you defined the RI between these
tables.

You can certainly do this by writing a trigger (on the remote) for
table A to delete the corresponding rows in table B.

--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng10 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/

Developer Community / Whitepapers
http://www.ianywhere.com/developer

Case-Express - to report bugs
http://case-express.sybase.com

CodeXchange - Free samples
http://ianywhere.codexchange.sybase.com/servlets/ProjectDocumentList