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.

Linkage Service

5 posts in DataWindow Last posting was on 2008-07-08 09:31:18.0Z
Anna Posted on 2008-07-02 19:36:25.0Z
Sender: 408e.486bd2ef.1804289383@sybase.com
From: Anna
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Linkage Service
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <486bd8b9.41ad.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 2 Jul 2008 12:36:25 -0700
X-Trace: forums-1-dub 1215027385 10.22.241.41 (2 Jul 2008 12:36:25 -0700)
X-Original-Trace: 2 Jul 2008 12:36:25 -0700, 10.22.241.41
Lines: 77
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87305
Article PK: 416562

I am using PB9 and I am trying to use the linkage service.
However, I get a foreign key constrain when deleting a row
in the master datawindow (I want the delete to cascade down
to the detail rows)
dw_site is my master row
dw_scope, dw_main and dw_crops are detail rows, all a the
same level

Here is my code in the OPEN evnt of the window

powerobject lpo_obj[]

lpo_obj[1] = dw_site
lpo_obj[2] = dw_scope
lpo_obj[3] = dw_main
lpo_obj[4] = dw_crops
of_SetUpdateObjects(lpo_obj)


dW_site.of_SetLinkage(true)
dw_crops.of_SetLInkage(true)
dW_scope.of_SetLinkage(true)
dw_main.of_SetLInkage(true)

dw_crops.inv_linkage.of_setMaster( dw_site )
dw_scope.inv_linkage.of_setMaster( dw_site )
dw_main.inv_linkage.of_setMaster( dw_site )


dw_crops.inv_linkage.of_Register( "ipcsite_csid","csid")
dw_main.inv_linkage.of_Register( "ipcsite_csid","csid")
dw_scope.inv_linkage.of_Register( "ipcsite_csid","csid")

//dw_crops.inv_linkage.of_setupdateonrowchange(true)
//dw_main.inv_linkage.of_setupdateonrowchange(true)
//dw_scope.inv_linkage.of_setupdateonrowchange(true)
//

//------------------------------------------------------------------------------
//First Order for UPDATES - top and then down
//Second Order for DELETES - down and then top
//------------------------------------------------------------------------------
dw_site.inv_linkage.of_SetUpdateStyle (
dw_site.inv_linkage.TOPDOWN_BOTTOMUP)


//------------------------------------------------------------------------------
//If row in master gets deleted, delete the associated
detail rows.
//------------------------------------------------------------------------------
dw_site.inv_linkage.of_SetDeleteStyle (
dw_site.inv_linkage.DELETE_ROWS)


//-------------------------------------------------------------------------------
//Set style to FILTER. Deletion of rows will not work
//with the RETRIEVE style. FYI - The SCROLL style will also
allow deletes.
//-------------------------------------------------------------------------------
dw_main.inv_linkage.of_setStyle(dw_main.inv_linkage.SCROLL)
dw_scope.inv_linkage.of_setStyle(dw_scope.inv_linkage.SCROLL)
dw_crops.inv_linkage.of_setStyle(dw_crops.inv_linkage.SCROLL)


dw_site.inv_linkage.of_SetTransObject(SQLCA)

//--------------------------------------------------------------------------------------------------------------------------
//Retrieve or insert new rows
//-------------------------------------------------------------------------------------------------------------------------
dw_site.inv_linkage.of_retrieve()



My delete command looks like
dw_site.EVENT pfc_deleterow()

What am I doing wrong?


Jim Madderra Posted on 2008-07-02 20:41:56.0Z
From: "Jim Madderra" <jmadderra@astound.net>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <486bd8b9.41ad.1681692777@sybase.com>
Subject: Re: Linkage Service
Lines: 85
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <486be814$1@forums-1-dub>
Date: 2 Jul 2008 13:41:56 -0700
X-Trace: forums-1-dub 1215031316 10.22.241.152 (2 Jul 2008 13:41:56 -0700)
X-Original-Trace: 2 Jul 2008 13:41:56 -0700, vip152.sybase.com
X-Authenticated-User: powerbuilder
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87307
Article PK: 416564

You probably need to change the linkage processing to bottomup - look at the
variables in inv_linkage - can't remember the syntax, but you need to change
the processing order (it's built-in, just need to set the variable or call a
function that sets it).

<Anna> wrote in message news:486bd8b9.41ad.1681692777@sybase.com...
>I am using PB9 and I am trying to use the linkage service.
> However, I get a foreign key constrain when deleting a row
> in the master datawindow (I want the delete to cascade down
> to the detail rows)
> dw_site is my master row
> dw_scope, dw_main and dw_crops are detail rows, all a the
> same level
>
> Here is my code in the OPEN evnt of the window
>
> powerobject lpo_obj[]
>
> lpo_obj[1] = dw_site
> lpo_obj[2] = dw_scope
> lpo_obj[3] = dw_main
> lpo_obj[4] = dw_crops
> of_SetUpdateObjects(lpo_obj)
>
>
> dW_site.of_SetLinkage(true)
> dw_crops.of_SetLInkage(true)
> dW_scope.of_SetLinkage(true)
> dw_main.of_SetLInkage(true)
>
> dw_crops.inv_linkage.of_setMaster( dw_site )
> dw_scope.inv_linkage.of_setMaster( dw_site )
> dw_main.inv_linkage.of_setMaster( dw_site )
>
>
> dw_crops.inv_linkage.of_Register( "ipcsite_csid","csid")
> dw_main.inv_linkage.of_Register( "ipcsite_csid","csid")
> dw_scope.inv_linkage.of_Register( "ipcsite_csid","csid")
>
> //dw_crops.inv_linkage.of_setupdateonrowchange(true)
> //dw_main.inv_linkage.of_setupdateonrowchange(true)
> //dw_scope.inv_linkage.of_setupdateonrowchange(true)
> //
>
> //------------------------------------------------------------------------------
> //First Order for UPDATES - top and then down
> //Second Order for DELETES - down and then top
> //------------------------------------------------------------------------------
> dw_site.inv_linkage.of_SetUpdateStyle (
> dw_site.inv_linkage.TOPDOWN_BOTTOMUP)
>
>
> //------------------------------------------------------------------------------
> //If row in master gets deleted, delete the associated
> detail rows.
> //------------------------------------------------------------------------------
> dw_site.inv_linkage.of_SetDeleteStyle (
> dw_site.inv_linkage.DELETE_ROWS)
>
>
> //-------------------------------------------------------------------------------
> //Set style to FILTER. Deletion of rows will not work
> //with the RETRIEVE style. FYI - The SCROLL style will also
> allow deletes.
> //-------------------------------------------------------------------------------
> dw_main.inv_linkage.of_setStyle(dw_main.inv_linkage.SCROLL)
> dw_scope.inv_linkage.of_setStyle(dw_scope.inv_linkage.SCROLL)
> dw_crops.inv_linkage.of_setStyle(dw_crops.inv_linkage.SCROLL)
>
>
> dw_site.inv_linkage.of_SetTransObject(SQLCA)
>
> //--------------------------------------------------------------------------------------------------------------------------
> //Retrieve or insert new rows
> //-------------------------------------------------------------------------------------------------------------------------
> dw_site.inv_linkage.of_retrieve()
>
>
>
> My delete command looks like
> dw_site.EVENT pfc_deleterow()
>
> What am I doing wrong?


Anna Posted on 2008-07-02 21:17:18.0Z
Sender: 408e.486bd2ef.1804289383@sybase.com
From: Anna
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Linkage Service
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <486bf05e.45e8.1681692777@sybase.com>
References: <486be814$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 2 Jul 2008 14:17:18 -0700
X-Trace: forums-1-dub 1215033438 10.22.241.41 (2 Jul 2008 14:17:18 -0700)
X-Original-Trace: 2 Jul 2008 14:17:18 -0700, 10.22.241.41
Lines: 103
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87308
Article PK: 416565

I would like updates to happen also that is why I have
TOPDOWN_BOTTOMUP. FOr deletes I did try BOTTOMUP only but I
still get the foreign key constraint message.

> You probably need to change the linkage processing to
> bottomup - look at the variables in inv_linkage - can't
> remember the syntax, but you need to change the
> processing order (it's built-in, just need to set the
> variable or call a function that sets it).
>
> <Anna> wrote in message
> news:486bd8b9.41ad.1681692777@sybase.com... >I am using
> > PB9 and I am trying to use the linkage service. However,
> > I get a foreign key constrain when deleting a row in the
> > master datawindow (I want the delete to cascade down to
> > the detail rows) dw_site is my master row
> > dw_scope, dw_main and dw_crops are detail rows, all a
> > the same level
> >
> > Here is my code in the OPEN evnt of the window
> >
> > powerobject lpo_obj[]
> >
> > lpo_obj[1] = dw_site
> > lpo_obj[2] = dw_scope
> > lpo_obj[3] = dw_main
> > lpo_obj[4] = dw_crops
> > of_SetUpdateObjects(lpo_obj)
> >
> >
> > dW_site.of_SetLinkage(true)
> > dw_crops.of_SetLInkage(true)
> > dW_scope.of_SetLinkage(true)
> > dw_main.of_SetLInkage(true)
> >
> > dw_crops.inv_linkage.of_setMaster( dw_site )
> > dw_scope.inv_linkage.of_setMaster( dw_site )
> > dw_main.inv_linkage.of_setMaster( dw_site )
> >
> >
> > dw_crops.inv_linkage.of_Register( "ipcsite_csid","csid")
> > dw_main.inv_linkage.of_Register( "ipcsite_csid","csid")
> > dw_scope.inv_linkage.of_Register( "ipcsite_csid","csid")
> >
> > //dw_crops.inv_linkage.of_setupdateonrowchange(true)
> > //dw_main.inv_linkage.of_setupdateonrowchange(true)
> > //dw_scope.inv_linkage.of_setupdateonrowchange(true)
> > //
> >
> >
> //--------------------------------------------------------
> > ---------------------- //First Order for UPDATES - top
> > and then down //Second Order for DELETES - down and then
> > top
> //--------------------------------------------------------
> > ----------------------
> > dw_site.inv_linkage.of_SetUpdateStyle (
> dw_site.inv_linkage.TOPDOWN_BOTTOMUP) >
> >
> >
> //--------------------------------------------------------
> > ---------------------- //If row in master gets deleted,
> > delete the associated detail rows.
> >
> //--------------------------------------------------------
> > ----------------------
> > dw_site.inv_linkage.of_SetDeleteStyle (
> dw_site.inv_linkage.DELETE_ROWS) >
> >
> >
> //--------------------------------------------------------
> > ----------------------- //Set style to FILTER. Deletion
> > of rows will not work //with the RETRIEVE style. FYI -
> > The SCROLL style will also allow deletes.
> >
> //--------------------------------------------------------
> > -----------------------
> dw_main.inv_linkage.of_setStyle(dw_main.inv_linkage.SCROLL
> > )
> dw_scope.inv_linkage.of_setStyle(dw_scope.inv_linkage.SCRO
> > LL)
> dw_crops.inv_linkage.of_setStyle(dw_crops.inv_linkage.SCRO
> LL) >
> >
> > dw_site.inv_linkage.of_SetTransObject(SQLCA)
> >
> >
> //--------------------------------------------------------
> ----------------------------------------------------------
> > -------- //Retrieve or insert new rows
> >
> //--------------------------------------------------------
> ----------------------------------------------------------
> > ------- dw_site.inv_linkage.of_retrieve()
> >
> >
> >
> > My delete command looks like
> > dw_site.EVENT pfc_deleterow()
> >
> > What am I doing wrong?
>
>


Jim Madderra Posted on 2008-07-03 19:06:14.0Z
From: "Jim Madderra" <jmadderra@astound.net>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <486be814$1@forums-1-dub> <486bf05e.45e8.1681692777@sybase.com>
Subject: Re: Linkage Service
Lines: 114
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <486d2326$1@forums-1-dub>
Date: 3 Jul 2008 12:06:14 -0700
X-Trace: forums-1-dub 1215111974 10.22.241.152 (3 Jul 2008 12:06:14 -0700)
X-Original-Trace: 3 Jul 2008 12:06:14 -0700, vip152.sybase.com
X-Authenticated-User: powerbuilder
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87309
Article PK: 416566

If you are updating the primary key, I think you're out of luck. In
general, that should NOT be done. If you need to, then you'll probably need
to 'roll your own', however as a design principle modifying primary keys
would be unusual. To do it, you should delete one and add back another (and
they'd of course be different)

Jim

<Anna> wrote in message news:486bf05e.45e8.1681692777@sybase.com...
>I would like updates to happen also that is why I have
> TOPDOWN_BOTTOMUP. FOr deletes I did try BOTTOMUP only but I
> still get the foreign key constraint message.
>
>> You probably need to change the linkage processing to
>> bottomup - look at the variables in inv_linkage - can't
>> remember the syntax, but you need to change the
>> processing order (it's built-in, just need to set the
>> variable or call a function that sets it).
>>
>> <Anna> wrote in message
>> news:486bd8b9.41ad.1681692777@sybase.com... >I am using
>> > PB9 and I am trying to use the linkage service. However,
>> > I get a foreign key constrain when deleting a row in the
>> > master datawindow (I want the delete to cascade down to
>> > the detail rows) dw_site is my master row
>> > dw_scope, dw_main and dw_crops are detail rows, all a
>> > the same level
>> >
>> > Here is my code in the OPEN evnt of the window
>> >
>> > powerobject lpo_obj[]
>> >
>> > lpo_obj[1] = dw_site
>> > lpo_obj[2] = dw_scope
>> > lpo_obj[3] = dw_main
>> > lpo_obj[4] = dw_crops
>> > of_SetUpdateObjects(lpo_obj)
>> >
>> >
>> > dW_site.of_SetLinkage(true)
>> > dw_crops.of_SetLInkage(true)
>> > dW_scope.of_SetLinkage(true)
>> > dw_main.of_SetLInkage(true)
>> >
>> > dw_crops.inv_linkage.of_setMaster( dw_site )
>> > dw_scope.inv_linkage.of_setMaster( dw_site )
>> > dw_main.inv_linkage.of_setMaster( dw_site )
>> >
>> >
>> > dw_crops.inv_linkage.of_Register( "ipcsite_csid","csid")
>> > dw_main.inv_linkage.of_Register( "ipcsite_csid","csid")
>> > dw_scope.inv_linkage.of_Register( "ipcsite_csid","csid")
>> >
>> > //dw_crops.inv_linkage.of_setupdateonrowchange(true)
>> > //dw_main.inv_linkage.of_setupdateonrowchange(true)
>> > //dw_scope.inv_linkage.of_setupdateonrowchange(true)
>> > //
>> >
>> >
>> //--------------------------------------------------------
>> > ---------------------- //First Order for UPDATES - top
>> > and then down //Second Order for DELETES - down and then
>> > top
>> //--------------------------------------------------------
>> > ----------------------
>> > dw_site.inv_linkage.of_SetUpdateStyle (
>> dw_site.inv_linkage.TOPDOWN_BOTTOMUP) >
>> >
>> >
>> //--------------------------------------------------------
>> > ---------------------- //If row in master gets deleted,
>> > delete the associated detail rows.
>> >
>> //--------------------------------------------------------
>> > ----------------------
>> > dw_site.inv_linkage.of_SetDeleteStyle (
>> dw_site.inv_linkage.DELETE_ROWS) >
>> >
>> >
>> //--------------------------------------------------------
>> > ----------------------- //Set style to FILTER. Deletion
>> > of rows will not work //with the RETRIEVE style. FYI -
>> > The SCROLL style will also allow deletes.
>> >
>> //--------------------------------------------------------
>> > -----------------------
>> dw_main.inv_linkage.of_setStyle(dw_main.inv_linkage.SCROLL
>> > )
>> dw_scope.inv_linkage.of_setStyle(dw_scope.inv_linkage.SCRO
>> > LL)
>> dw_crops.inv_linkage.of_setStyle(dw_crops.inv_linkage.SCRO
>> LL) >
>> >
>> > dw_site.inv_linkage.of_SetTransObject(SQLCA)
>> >
>> >
>> //--------------------------------------------------------
>> ----------------------------------------------------------
>> > -------- //Retrieve or insert new rows
>> >
>> //--------------------------------------------------------
>> ----------------------------------------------------------
>> > ------- dw_site.inv_linkage.of_retrieve()
>> >
>> >
>> >
>> > My delete command looks like
>> > dw_site.EVENT pfc_deleterow()
>> >
>> > What am I doing wrong?
>>
>>


dps Posted on 2008-07-08 09:31:18.0Z
From: dps <patrice.domange@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Linkage Service
Date: Tue, 8 Jul 2008 02:31:18 -0700 (PDT)
Organization: http://groups.google.com
Lines: 121
Message-ID: <8e395cee-2996-448e-97d3-748646da018f@c58g2000hsc.googlegroups.com>
References: <486be814$1@forums-1-dub> <486bf05e.45e8.1681692777@sybase.com> <486d2326$1@forums-1-dub>
NNTP-Posting-Host: 213.31.232.166
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1215509478 29447 127.0.0.1 (8 Jul 2008 09:31:18 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 8 Jul 2008 09:31:18 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: c58g2000hsc.googlegroups.com; posting-host=213.31.232.166; posting-account=vzicngoAAAD7lyTWQ2Cc4y8bFreSvABW
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!newsfeed.yul.equant.net!nntp1.roc.gblx.net!nntp.gblx.net!nntp.gblx.net!nlpi057.nbdc.sbc.com!prodigy.net!border1.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!c58g2000hsc.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87330
Article PK: 416587


On 3 juil, 21:06, "Jim Madderra" <jmadde...@astound.net> wrote:
> If you are updating the primary key, I think you're out of luck.  In
> general, that should NOT be done.  If you need to, then you'll probably need
> to 'roll your own', however as a design principle modifying primary keys
> would be unusual.  To do it, you should delete one and add back another (and
> they'd of course be different)
>
> Jim
>
>
>
> <Anna> wrote in messagenews:486bf05e.45e8.1681692777@sybase.com...
> >I would like updates to happen also that is why I have
> > TOPDOWN_BOTTOMUP.  FOr deletes I did try BOTTOMUP only but I
> > still get the foreign key constraint message.
>
> >> You probably need to change the linkage processing to
> >> bottomup - look at the  variables in inv_linkage - can't
> >> remember the syntax, but you need to change  the
> >> processing order (it's built-in, just need to set the
> >> variable or call a  function that sets it).
>
> >> <Anna> wrote in message
> >>news:486bd8b9.41ad.1681692777@sybase.com... >I am using
> >> > PB9 and I am trying to use the linkage service. However,
> >> > I get a foreign key constrain when deleting a row in the
> >> > master datawindow (I want the delete to cascade down to
> >> > the detail rows) dw_site is my master row
> >> > dw_scope, dw_main and dw_crops are detail rows, all a
> >> > the same level
>
> >> > Here is my code in the OPEN evnt of the window
>
> >> > powerobject lpo_obj[]
>
> >> > lpo_obj[1] = dw_site
> >> > lpo_obj[2] = dw_scope
> >> > lpo_obj[3] = dw_main
> >> > lpo_obj[4] = dw_crops
> >> > of_SetUpdateObjects(lpo_obj)
>
> >> > dW_site.of_SetLinkage(true)
> >> > dw_crops.of_SetLInkage(true)
> >> > dW_scope.of_SetLinkage(true)
> >> > dw_main.of_SetLInkage(true)
>
> >> > dw_crops.inv_linkage.of_setMaster( dw_site )
> >> > dw_scope.inv_linkage.of_setMaster( dw_site )
> >> > dw_main.inv_linkage.of_setMaster( dw_site )
>
> >> > dw_crops.inv_linkage.of_Register( "ipcsite_csid","csid")
> >> > dw_main.inv_linkage.of_Register( "ipcsite_csid","csid")
> >> > dw_scope.inv_linkage.of_Register( "ipcsite_csid","csid")
>
> >> > //dw_crops.inv_linkage.of_setupdateonrowchange(true)
> >> > //dw_main.inv_linkage.of_setupdateonrowchange(true)
> >> > //dw_scope.inv_linkage.of_setupdateonrowchange(true)
> >> > //
>
> >> //--------------------------------------------------------
> >> > ---------------------- //First Order for UPDATES - top
> >> > and then down //Second Order for DELETES - down and then
> >> > top
> >> //--------------------------------------------------------
> >> > ----------------------
> >> > dw_site.inv_linkage.of_SetUpdateStyle (
> >> dw_site.inv_linkage.TOPDOWN_BOTTOMUP) >
>
> >> //--------------------------------------------------------
> >> > ---------------------- //If row in master gets deleted,
> >> > delete the associated detail rows.
>
> >> //--------------------------------------------------------
> >> > ----------------------
> >> > dw_site.inv_linkage.of_SetDeleteStyle (
> >> dw_site.inv_linkage.DELETE_ROWS) >
>
> >> //--------------------------------------------------------
> >> > ----------------------- //Set style to FILTER.  Deletion
> >> > of rows will not work //with the RETRIEVE style.  FYI -
> >> > The SCROLL style will also allow deletes.
>
> >> //--------------------------------------------------------
> >> > -----------------------
> >> dw_main.inv_linkage.of_setStyle(dw_main.inv_linkage.SCROLL
> >> > )
> >> dw_scope.inv_linkage.of_setStyle(dw_scope.inv_linkage.SCRO
> >> > LL)
> >> dw_crops.inv_linkage.of_setStyle(dw_crops.inv_linkage.SCRO
> >> LL) >
>
> >> > dw_site.inv_linkage.of_SetTransObject(SQLCA)
>
> >> //--------------------------------------------------------
> >> ----------------------------------------------------------
> >> > -------- //Retrieve or insert new rows
>
> >> //--------------------------------------------------------
> >> ----------------------------------------------------------
> >> > ------- dw_site.inv_linkage.of_retrieve()
>
> >> > My delete command looks like
> >> > dw_site.EVENT pfc_deleterow()
>
> >> > What am I doing wrong?- Masquer le texte des messages précédents -
>
> - Afficher le texte des messages précédents -

What are the db integrity constraints defined in your case ?
May be you could put it as a cascade delete when the primary key is
deleted, letting the database do the job for you.
Of course, you should set the style to DISCARD_ROWS.

If, you do not want to change the db integrity constraints, simply set
the Style to DEFAULT, that way no detail rows will be deleted by the
linkage service, but you will have to code your own deletion process !

Regards,