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.

Delete rows without moving to delete buffer

18 posts in DataWindow Last posting was on 2008-06-10 19:48:21.0Z
Louis Antony Posted on 2008-06-06 14:53:43.0Z
Sender: 3aec.48494ea2.1804289383@sybase.com
From: Louis Antony
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Delete rows without moving to delete buffer
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <48494f77.3b16.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 6 Jun 2008 07:53:43 -0700
X-Trace: forums-1-dub 1212764023 10.22.241.41 (6 Jun 2008 07:53:43 -0700)
X-Original-Trace: 6 Jun 2008 07:53:43 -0700, 10.22.241.41
Lines: 2
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87093
Article PK: 416352

Is there any method with which we can delete rows from
datawindow without moving rows to delete buffer?


"Jason 'Bug' Fenter [TeamSybase]" <NO_SPAMMING_jason.fenter_ Posted on 2008-06-06 14:55:13.0Z
From: "Jason 'Bug' Fenter [TeamSybase]" <NO_SPAMMING_jason.fenter_@_teamsybase.com>
User-Agent: Thunderbird 2.0.0.14 (Windows/20080421)
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Delete rows without moving to delete buffer
References: <48494f77.3b16.1681692777@sybase.com>
In-Reply-To: <48494f77.3b16.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48494fd1$1@forums-1-dub>
Date: 6 Jun 2008 07:55:13 -0700
X-Trace: forums-1-dub 1212764113 10.22.241.152 (6 Jun 2008 07:55:13 -0700)
X-Original-Trace: 6 Jun 2008 07:55:13 -0700, vip152.sybase.com
Lines: 9
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87094
Article PK: 416350

RowsDiscard()

This will *not* remove the rows from the database.

Louis Antony wrote:
> Is there any method with which we can delete rows from
> datawindow without moving rows to delete buffer?


Louis Antony Posted on 2008-06-06 14:59:54.0Z
Sender: 3aec.48494ea2.1804289383@sybase.com
From: Louis Antony
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Delete rows without moving to delete buffer
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <484950ea.3b72.1681692777@sybase.com>
References: <48494fd1$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 6 Jun 2008 07:59:54 -0700
X-Trace: forums-1-dub 1212764394 10.22.241.41 (6 Jun 2008 07:59:54 -0700)
X-Original-Trace: 6 Jun 2008 07:59:54 -0700, 10.22.241.41
Lines: 12
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87095
Article PK: 416353

Thanks for the answer. But I need to remove rows from
database also.

> RowsDiscard()
>
> This will *not* remove the rows from the database.
>
>
>
> Louis Antony wrote:
> > Is there any method with which we can delete rows from
> > datawindow without moving rows to delete buffer?


Arthur Hefti Posted on 2008-06-06 15:01:49.0Z
From: "Arthur Hefti" <arthur@catsoft.ch>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <48494fd1$1@forums-1-dub> <484950ea.3b72.1681692777@sybase.com>
Subject: Re: Delete rows without moving to delete buffer
Lines: 21
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5512
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4849515d@forums-1-dub>
Date: 6 Jun 2008 08:01:49 -0700
X-Trace: forums-1-dub 1212764509 10.22.241.152 (6 Jun 2008 08:01:49 -0700)
X-Original-Trace: 6 Jun 2008 08:01:49 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87096
Article PK: 416351

Why don't you want to move them to the delete buffer?
If not you have to loop through you rows and use embedded SQL to delete the
rows from the db.

Arthur

<Louis Antony> wrote in message news:484950ea.3b72.1681692777@sybase.com...
> Thanks for the answer. But I need to remove rows from
> database also.
>
>> RowsDiscard()
>>
>> This will *not* remove the rows from the database.
>>
>>
>>
>> Louis Antony wrote:
>> > Is there any method with which we can delete rows from
>> > datawindow without moving rows to delete buffer?


Louis Antony Posted on 2008-06-06 15:07:00.0Z
Sender: 3aec.48494ea2.1804289383@sybase.com
From: Louis Antony
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Delete rows without moving to delete buffer
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <48495294.3bcd.1681692777@sybase.com>
References: <4849515d@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 6 Jun 2008 08:07:00 -0700
X-Trace: forums-1-dub 1212764820 10.22.241.41 (6 Jun 2008 08:07:00 -0700)
X-Original-Trace: 6 Jun 2008 08:07:00 -0700, 10.22.241.41
Lines: 25
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87097
Article PK: 416354

I had to face this question in an interview and they want it
to be done with datawindow; not with any embeded sql
statements.

> Why don't you want to move them to the delete buffer?
> If not you have to loop through you rows and use embedded
> SQL to delete the rows from the db.
>
> Arthur
>
> <Louis Antony> wrote in message
> > news:484950ea.3b72.1681692777@sybase.com... Thanks for
> > the answer. But I need to remove rows from database
> also. >
> >> RowsDiscard()
> >>
> >> This will *not* remove the rows from the database.
> >>
> >>
> >>
> >> Louis Antony wrote:
> >> > Is there any method with which we can delete rows
> from >> > datawindow without moving rows to delete buffer?
>
>


Arthur Hefti Posted on 2008-06-06 15:08:42.0Z
From: "Arthur Hefti" <arthur@catsoft.ch>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4849515d@forums-1-dub> <48495294.3bcd.1681692777@sybase.com>
Subject: Re: Delete rows without moving to delete buffer
Lines: 31
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5512
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <484952fa$1@forums-1-dub>
Date: 6 Jun 2008 08:08:42 -0700
X-Trace: forums-1-dub 1212764922 10.22.241.152 (6 Jun 2008 08:08:42 -0700)
X-Original-Trace: 6 Jun 2008 08:08:42 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87098
Article PK: 416355

A datawindow only deletes rows from the db when they are in the deleted
buffer....

<Louis Antony> wrote in message news:48495294.3bcd.1681692777@sybase.com...
>I had to face this question in an interview and they want it
> to be done with datawindow; not with any embeded sql
> statements.
>
>> Why don't you want to move them to the delete buffer?
>> If not you have to loop through you rows and use embedded
>> SQL to delete the rows from the db.
>>
>> Arthur
>>
>> <Louis Antony> wrote in message
>> > news:484950ea.3b72.1681692777@sybase.com... Thanks for
>> > the answer. But I need to remove rows from database
>> also. >
>> >> RowsDiscard()
>> >>
>> >> This will *not* remove the rows from the database.
>> >>
>> >>
>> >>
>> >> Louis Antony wrote:
>> >> > Is there any method with which we can delete rows
>> from >> > datawindow without moving rows to delete buffer?
>>
>>


HarryLai Posted on 2008-06-06 16:05:46.0Z
From: "HarryLai" <nospam_harrylhy@bigfoot.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4849515d@forums-1-dub> <48495294.3bcd.1681692777@sybase.com>
Subject: Re: Delete rows without moving to delete buffer
Lines: 35
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: <4849605a$1@forums-1-dub>
Date: 6 Jun 2008 09:05:46 -0700
X-Trace: forums-1-dub 1212768346 10.22.241.152 (6 Jun 2008 09:05:46 -0700)
X-Original-Trace: 6 Jun 2008 09:05:46 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87099
Article PK: 416356

How about ...

1. Move the rows to another datawindow or datastore, and detele these rows whent save?

2. Add one column to table for mark the rows that need to delete (e.g.: del_flag = 1), then delete these rows in trigger after save.


<Louis Antony> ¼¶¼g©ó¶l¥ó·s»D:48495294.3bcd.1681692777@sybase.com...

>I had to face this question in an interview and they want it
> to be done with datawindow; not with any embeded sql
> statements.
>
>> Why don't you want to move them to the delete buffer?
>> If not you have to loop through you rows and use embedded
>> SQL to delete the rows from the db.
>>
>> Arthur
>>
>> <Louis Antony> wrote in message
>> > news:484950ea.3b72.1681692777@sybase.com... Thanks for
>> > the answer. But I need to remove rows from database
>> also. >
>> >> RowsDiscard()
>> >>
>> >> This will *not* remove the rows from the database.
>> >>
>> >>
>> >>
>> >> Louis Antony wrote:
>> >> > Is there any method with which we can delete rows
>> from >> > datawindow without moving rows to delete buffer?
>>
>>


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2008-06-06 21:50:42.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4849515d@forums-1-dub> <48495294.3bcd.1681692777@sybase.com>
Subject: Re: Delete rows without moving to delete buffer
Lines: 30
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5512
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4849b132$1@forums-1-dub>
Date: 6 Jun 2008 14:50:42 -0700
X-Trace: forums-1-dub 1212789042 10.22.241.152 (6 Jun 2008 14:50:42 -0700)
X-Original-Trace: 6 Jun 2008 14:50:42 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87111
Article PK: 416369

Mess with the DDL in SQLPreview?

<Louis Antony> wrote in message news:48495294.3bcd.1681692777@sybase.com...
>I had to face this question in an interview and they want it
> to be done with datawindow; not with any embeded sql
> statements.
>
>> Why don't you want to move them to the delete buffer?
>> If not you have to loop through you rows and use embedded
>> SQL to delete the rows from the db.
>>
>> Arthur
>>
>> <Louis Antony> wrote in message
>> > news:484950ea.3b72.1681692777@sybase.com... Thanks for
>> > the answer. But I need to remove rows from database
>> also. >
>> >> RowsDiscard()
>> >>
>> >> This will *not* remove the rows from the database.
>> >>
>> >>
>> >>
>> >> Louis Antony wrote:
>> >> > Is there any method with which we can delete rows
>> from >> > datawindow without moving rows to delete buffer?
>>
>>


Arnd Schmidt Posted on 2008-06-07 12:12:10.0Z
From: Arnd Schmidt <arnd.schmidt@gmx.de>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Delete rows without moving to delete buffer
Message-ID: <uiuk44lhs02piu5vmps7a45doegq739r89@4ax.com>
References: <4849515d@forums-1-dub> <48495294.3bcd.1681692777@sybase.com> <4849b132$1@forums-1-dub>
X-Newsreader: Forte Agent 1.8/32.548
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 7 Jun 2008 05:12:10 -0700
X-Trace: forums-1-dub 1212840730 10.22.241.152 (7 Jun 2008 05:12:10 -0700)
X-Original-Trace: 7 Jun 2008 05:12:10 -0700, vip152.sybase.com
Lines: 40
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87115
Article PK: 416372

>Mess with the DDL in SQLPreview?
Interesting short answer as a question, but without explanation.

When will DDL be used in SQLPreview?

Arnd

On 6 Jun 2008 14:50:42 -0700, "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com> wrote:

>Mess with the DDL in SQLPreview?
>
><Louis Antony> wrote in message news:48495294.3bcd.1681692777@sybase.com...
>>I had to face this question in an interview and they want it
>> to be done with datawindow; not with any embeded sql
>> statements.
>>
>>> Why don't you want to move them to the delete buffer?
>>> If not you have to loop through you rows and use embedded
>>> SQL to delete the rows from the db.
>>>
>>> Arthur
>>>
>>> <Louis Antony> wrote in message
>>> > news:484950ea.3b72.1681692777@sybase.com... Thanks for
>>> > the answer. But I need to remove rows from database
>>> also. >
>>> >> RowsDiscard()
>>> >>
>>> >> This will *not* remove the rows from the database.
>>> >>
>>> >>
>>> >>
>>> >> Louis Antony wrote:
>>> >> > Is there any method with which we can delete rows
>>> from >> > datawindow without moving rows to delete buffer?
>>>
>>>
>


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2008-06-08 03:07:44.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4849515d@forums-1-dub> <48495294.3bcd.1681692777@sybase.com> <4849b132$1@forums-1-dub> <uiuk44lhs02piu5vmps7a45doegq739r89@4ax.com>
Subject: Re: Delete rows without moving to delete buffer
Lines: 48
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5512
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <484b4d00@forums-1-dub>
Date: 7 Jun 2008 20:07:44 -0700
X-Trace: forums-1-dub 1212894464 10.22.241.152 (7 Jun 2008 20:07:44 -0700)
X-Original-Trace: 7 Jun 2008 20:07:44 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87116
Article PK: 416373

Senior moment! Would you believe DML?

"Arnd Schmidt" <arnd.schmidt@gmx.de> wrote in message
news:uiuk44lhs02piu5vmps7a45doegq739r89@4ax.com...
> >Mess with the DDL in SQLPreview?
> Interesting short answer as a question, but without explanation.
>
> When will DDL be used in SQLPreview?
>
> Arnd
>
>
> On 6 Jun 2008 14:50:42 -0700, "Jerry Siegel [TeamSybase]"
> <jNOsSPAMsiegel@yahoo!.com> wrote:
>
>>Mess with the DDL in SQLPreview?
>>
>><Louis Antony> wrote in message
>>news:48495294.3bcd.1681692777@sybase.com...
>>>I had to face this question in an interview and they want it
>>> to be done with datawindow; not with any embeded sql
>>> statements.
>>>
>>>> Why don't you want to move them to the delete buffer?
>>>> If not you have to loop through you rows and use embedded
>>>> SQL to delete the rows from the db.
>>>>
>>>> Arthur
>>>>
>>>> <Louis Antony> wrote in message
>>>> > news:484950ea.3b72.1681692777@sybase.com... Thanks for
>>>> > the answer. But I need to remove rows from database
>>>> also. >
>>>> >> RowsDiscard()
>>>> >>
>>>> >> This will *not* remove the rows from the database.
>>>> >>
>>>> >>
>>>> >>
>>>> >> Louis Antony wrote:
>>>> >> > Is there any method with which we can delete rows
>>>> from >> > datawindow without moving rows to delete buffer?
>>>>
>>>>
>>
>


Chris Pollach Posted on 2008-06-09 11:44:15.0Z
From: "Chris Pollach" <cpollach@travel-net.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4849515d@forums-1-dub> <48495294.3bcd.1681692777@sybase.com>
Subject: Re: Delete rows without moving to delete buffer
Lines: 50
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: <484d178f@forums-1-dub>
Date: 9 Jun 2008 04:44:15 -0700
X-Trace: forums-1-dub 1213011855 10.22.241.152 (9 Jun 2008 04:44:15 -0700)
X-Original-Trace: 9 Jun 2008 04:44:15 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87119
Article PK: 416376

Hi Louis;

You were posed an interesting question! This is how I would do it ...

1) Add a computed SQL column (ie: cc_delete)
2) Add a filter to the DWO to filter where cc_delete = 'Y'
3) When the user requests a Delete - set the computed column to "Y" and it
should disappear.

When a physical delete is required ... move the filter buffer to the Delete
buffer and perform an Update. The interesting bonus behind this approach is
to cancel all the pending deletes by just setting the Filter to "" if the
user wants to back out of the multi-row delete sequence. :-)

HTH

--
Regards ... Chris
ISUG - NA RUG Director
http://chrispollach.pbdjmagazine.com

<Louis Antony> wrote in message news:48495294.3bcd.1681692777@sybase.com...
>I had to face this question in an interview and they want it
> to be done with datawindow; not with any embeded sql
> statements.
>
>> Why don't you want to move them to the delete buffer?
>> If not you have to loop through you rows and use embedded
>> SQL to delete the rows from the db.
>>
>> Arthur
>>
>> <Louis Antony> wrote in message
>> > news:484950ea.3b72.1681692777@sybase.com... Thanks for
>> > the answer. But I need to remove rows from database
>> also. >
>> >> RowsDiscard()
>> >>
>> >> This will *not* remove the rows from the database.
>> >>
>> >>
>> >>
>> >> Louis Antony wrote:
>> >> > Is there any method with which we can delete rows
>> from >> > datawindow without moving rows to delete buffer?
>>
>>


Arnd Schmidt Posted on 2008-06-09 20:51:53.0Z
From: Arnd Schmidt <arnd.schmidt@gmx.de>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Delete rows without moving to delete buffer
Message-ID: <ud4r44hqstd5i1i1ivrhi02pust5vmibfm@4ax.com>
References: <4849515d@forums-1-dub> <48495294.3bcd.1681692777@sybase.com> <484d178f@forums-1-dub>
X-Newsreader: Forte Agent 1.8/32.548
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 9 Jun 2008 13:51:53 -0700
X-Trace: forums-1-dub 1213044713 10.22.241.152 (9 Jun 2008 13:51:53 -0700)
X-Original-Trace: 9 Jun 2008 13:51:53 -0700, vip152.sybase.com
Lines: 38
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87128
Article PK: 416385

Because moving rows to the delete buffer will violate the "subject",
why not using use a stored procedure-update?
The SP deletes the rows in the database where @cc_delete = "Y"
and after successfull Update() perform a row discard on cc_delete = "Y" rows
in the filter.

Maybe the folks had a framework, where they used such an approach.

I used a framework where _all_ DB transactions were done via
stored procdures, but the framework did not used the built-in DW SP features.
Instead there was a repository based service class, that does a match
against a tag based security sytsem to get the rights and the to be used procedure
for an insert / update / delete. For sure, if no SP was configured for the
user, the insert, delete or save buttons and also dw features where automatically
disabled by the framework.


Arnd

On 9 Jun 2008 04:44:15 -0700, "Chris Pollach" <cpollach@travel-net.com> wrote:

>Hi Louis;
>
> You were posed an interesting question! This is how I would do it ...
>
>1) Add a computed SQL column (ie: cc_delete)
>2) Add a filter to the DWO to filter where cc_delete = 'Y'
>3) When the user requests a Delete - set the computed column to "Y" and it
>should disappear.
>
>When a physical delete is required ... move the filter buffer to the Delete
>buffer and perform an Update. The interesting bonus behind this approach is
>to cancel all the pending deletes by just setting the Filter to "" if the
>user wants to back out of the multi-row delete sequence. :-)
>
>HTH


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2008-06-09 21:19:48.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4849515d@forums-1-dub> <48495294.3bcd.1681692777@sybase.com> <484d178f@forums-1-dub> <ud4r44hqstd5i1i1ivrhi02pust5vmibfm@4ax.com>
Subject: Re: Delete rows without moving to delete buffer
Lines: 54
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.5512
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <484d9e74$1@forums-1-dub>
Date: 9 Jun 2008 14:19:48 -0700
X-Trace: forums-1-dub 1213046388 10.22.241.152 (9 Jun 2008 14:19:48 -0700)
X-Original-Trace: 9 Jun 2008 14:19:48 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87129
Article PK: 416386

I'm beginning to think it was a trick question! The DW generates a delete if
and only if the row is in the delete buffer, and the only way to get around
that is to twiddle the SQL in SQLPreview or write your own, embedded or in
an SP.

"Arnd Schmidt" <arnd.schmidt@gmx.de> wrote in message
news:ud4r44hqstd5i1i1ivrhi02pust5vmibfm@4ax.com...
> Because moving rows to the delete buffer will violate the "subject",
> why not using use a stored procedure-update?
> The SP deletes the rows in the database where @cc_delete = "Y"
> and after successfull Update() perform a row discard on cc_delete = "Y"
> rows
> in the filter.
>
> Maybe the folks had a framework, where they used such an approach.
>
> I used a framework where _all_ DB transactions were done via
> stored procdures, but the framework did not used the built-in DW SP
> features.
> Instead there was a repository based service class, that does a match
> against a tag based security sytsem to get the rights and the to be used
> procedure
> for an insert / update / delete. For sure, if no SP was configured for the
> user, the insert, delete or save buttons and also dw features where
> automatically
> disabled by the framework.
>
>
> Arnd
>
>
> On 9 Jun 2008 04:44:15 -0700, "Chris Pollach" <cpollach@travel-net.com>
> wrote:
>
>>Hi Louis;
>>
>> You were posed an interesting question! This is how I would do it ...
>>
>>1) Add a computed SQL column (ie: cc_delete)
>>2) Add a filter to the DWO to filter where cc_delete = 'Y'
>>3) When the user requests a Delete - set the computed column to "Y" and it
>>should disappear.
>>
>>When a physical delete is required ... move the filter buffer to the
>>Delete
>>buffer and perform an Update. The interesting bonus behind this approach
>>is
>>to cancel all the pending deletes by just setting the Filter to "" if the
>>user wants to back out of the multi-row delete sequence. :-)
>>
>>HTH
>


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2008-06-09 21:29:03.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4849515d@forums-1-dub> <48495294.3bcd.1681692777@sybase.com> <484d178f@forums-1-dub> <ud4r44hqstd5i1i1ivrhi02pust5vmibfm@4ax.com> <484d9e74$1@forums-1-dub>
Subject: Re: Delete rows without moving to delete buffer
Lines: 63
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.5512
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <484da09f$1@forums-1-dub>
Date: 9 Jun 2008 14:29:03 -0700
X-Trace: forums-1-dub 1213046943 10.22.241.152 (9 Jun 2008 14:29:03 -0700)
X-Original-Trace: 9 Jun 2008 14:29:03 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87130
Article PK: 416388

Except for a changed key column with the option set to delete and insert
rather than update in place.

"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com> wrote in message
news:484d9e74$1@forums-1-dub...
> I'm beginning to think it was a trick question! The DW generates a delete
> if and only if the row is in the delete buffer, and the only way to get
> around that is to twiddle the SQL in SQLPreview or write your own,
> embedded or in an SP.
>
> "Arnd Schmidt" <arnd.schmidt@gmx.de> wrote in message
> news:ud4r44hqstd5i1i1ivrhi02pust5vmibfm@4ax.com...
>> Because moving rows to the delete buffer will violate the "subject",
>> why not using use a stored procedure-update?
>> The SP deletes the rows in the database where @cc_delete = "Y"
>> and after successfull Update() perform a row discard on cc_delete = "Y"
>> rows
>> in the filter.
>>
>> Maybe the folks had a framework, where they used such an approach.
>>
>> I used a framework where _all_ DB transactions were done via
>> stored procdures, but the framework did not used the built-in DW SP
>> features.
>> Instead there was a repository based service class, that does a match
>> against a tag based security sytsem to get the rights and the to be used
>> procedure
>> for an insert / update / delete. For sure, if no SP was configured for
>> the
>> user, the insert, delete or save buttons and also dw features where
>> automatically
>> disabled by the framework.
>>
>>
>> Arnd
>>
>>
>> On 9 Jun 2008 04:44:15 -0700, "Chris Pollach" <cpollach@travel-net.com>
>> wrote:
>>
>>>Hi Louis;
>>>
>>> You were posed an interesting question! This is how I would do it ...
>>>
>>>1) Add a computed SQL column (ie: cc_delete)
>>>2) Add a filter to the DWO to filter where cc_delete = 'Y'
>>>3) When the user requests a Delete - set the computed column to "Y" and
>>>it
>>>should disappear.
>>>
>>>When a physical delete is required ... move the filter buffer to the
>>>Delete
>>>buffer and perform an Update. The interesting bonus behind this approach
>>>is
>>>to cancel all the pending deletes by just setting the Filter to "" if the
>>>user wants to back out of the multi-row delete sequence. :-)
>>>
>>>HTH
>>
>
>


Arnd Schmidt Posted on 2008-06-10 19:00:13.0Z
From: Arnd Schmidt <arnd.schmidt@gmx.de>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Delete rows without moving to delete buffer
Message-ID: <q7jt44lu4duf0r9kges1h72ailbce4sick@4ax.com>
References: <4849515d@forums-1-dub> <48495294.3bcd.1681692777@sybase.com> <484d178f@forums-1-dub> <ud4r44hqstd5i1i1ivrhi02pust5vmibfm@4ax.com> <484d9e74$1@forums-1-dub> <484da09f$1@forums-1-dub>
X-Newsreader: Forte Agent 1.8/32.548
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 10 Jun 2008 12:00:13 -0700
X-Trace: forums-1-dub 1213124413 10.22.241.152 (10 Jun 2008 12:00:13 -0700)
X-Original-Trace: 10 Jun 2008 12:00:13 -0700, vip152.sybase.com
Lines: 77
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87136
Article PK: 416398

To allow changing a key column (primary key) was not an option.
All PKs were invisible or non editalbe columns for the end user.
Also the SPs checked the "generic" last modified user/date informations
that has been previously retrieved.

Did you see some scenarios where key modification were used in this way (delete / insert)?

I am really interested when this could make sense.

Arnd

On 9 Jun 2008 14:29:03 -0700, "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com> wrote:

>Except for a changed key column with the option set to delete and insert
>rather than update in place.
>
>"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com> wrote in message
>news:484d9e74$1@forums-1-dub...
>> I'm beginning to think it was a trick question! The DW generates a delete
>> if and only if the row is in the delete buffer, and the only way to get
>> around that is to twiddle the SQL in SQLPreview or write your own,
>> embedded or in an SP.
>>
>> "Arnd Schmidt" <arnd.schmidt@gmx.de> wrote in message
>> news:ud4r44hqstd5i1i1ivrhi02pust5vmibfm@4ax.com...
>>> Because moving rows to the delete buffer will violate the "subject",
>>> why not using use a stored procedure-update?
>>> The SP deletes the rows in the database where @cc_delete = "Y"
>>> and after successfull Update() perform a row discard on cc_delete = "Y"
>>> rows
>>> in the filter.
>>>
>>> Maybe the folks had a framework, where they used such an approach.
>>>
>>> I used a framework where _all_ DB transactions were done via
>>> stored procdures, but the framework did not used the built-in DW SP
>>> features.
>>> Instead there was a repository based service class, that does a match
>>> against a tag based security sytsem to get the rights and the to be used
>>> procedure
>>> for an insert / update / delete. For sure, if no SP was configured for
>>> the
>>> user, the insert, delete or save buttons and also dw features where
>>> automatically
>>> disabled by the framework.
>>>
>>>
>>> Arnd
>>>
>>>
>>> On 9 Jun 2008 04:44:15 -0700, "Chris Pollach" <cpollach@travel-net.com>
>>> wrote:
>>>
>>>>Hi Louis;
>>>>
>>>> You were posed an interesting question! This is how I would do it ...
>>>>
>>>>1) Add a computed SQL column (ie: cc_delete)
>>>>2) Add a filter to the DWO to filter where cc_delete = 'Y'
>>>>3) When the user requests a Delete - set the computed column to "Y" and
>>>>it
>>>>should disappear.
>>>>
>>>>When a physical delete is required ... move the filter buffer to the
>>>>Delete
>>>>buffer and perform an Update. The interesting bonus behind this approach
>>>>is
>>>>to cancel all the pending deletes by just setting the Filter to "" if the
>>>>user wants to back out of the multi-row delete sequence. :-)
>>>>
>>>>HTH
>>>
>>
>>
>


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2008-06-10 19:12:05.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4849515d@forums-1-dub> <48495294.3bcd.1681692777@sybase.com> <484d178f@forums-1-dub> <ud4r44hqstd5i1i1ivrhi02pust5vmibfm@4ax.com> <484d9e74$1@forums-1-dub> <484da09f$1@forums-1-dub> <q7jt44lu4duf0r9kges1h72ailbce4sick@4ax.com>
Subject: Re: Delete rows without moving to delete buffer
Lines: 93
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5512
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <484ed205$1@forums-1-dub>
Date: 10 Jun 2008 12:12:05 -0700
X-Trace: forums-1-dub 1213125125 10.22.241.152 (10 Jun 2008 12:12:05 -0700)
X-Original-Trace: 10 Jun 2008 12:12:05 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87137
Article PK: 416391

I don't believe I ever used the delete/insert option - always synthetic
keys, so it was never needed.
Could be the way to go if you needed to cascade delete referential integity
related rows, which no longer connected because the natural key changed.

"Arnd Schmidt" <arnd.schmidt@gmx.de> wrote in message
news:q7jt44lu4duf0r9kges1h72ailbce4sick@4ax.com...
> To allow changing a key column (primary key) was not an option.
> All PKs were invisible or non editalbe columns for the end user.
> Also the SPs checked the "generic" last modified user/date informations
> that has been previously retrieved.
>
> Did you see some scenarios where key modification were used in this way
> (delete / insert)?
>
> I am really interested when this could make sense.
>
> Arnd
>
>
> On 9 Jun 2008 14:29:03 -0700, "Jerry Siegel [TeamSybase]"
> <jNOsSPAMsiegel@yahoo!.com> wrote:
>
>>Except for a changed key column with the option set to delete and insert
>>rather than update in place.
>>
>>"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com> wrote in message
>>news:484d9e74$1@forums-1-dub...
>>> I'm beginning to think it was a trick question! The DW generates a
>>> delete
>>> if and only if the row is in the delete buffer, and the only way to get
>>> around that is to twiddle the SQL in SQLPreview or write your own,
>>> embedded or in an SP.
>>>
>>> "Arnd Schmidt" <arnd.schmidt@gmx.de> wrote in message
>>> news:ud4r44hqstd5i1i1ivrhi02pust5vmibfm@4ax.com...
>>>> Because moving rows to the delete buffer will violate the "subject",
>>>> why not using use a stored procedure-update?
>>>> The SP deletes the rows in the database where @cc_delete = "Y"
>>>> and after successfull Update() perform a row discard on cc_delete = "Y"
>>>> rows
>>>> in the filter.
>>>>
>>>> Maybe the folks had a framework, where they used such an approach.
>>>>
>>>> I used a framework where _all_ DB transactions were done via
>>>> stored procdures, but the framework did not used the built-in DW SP
>>>> features.
>>>> Instead there was a repository based service class, that does a match
>>>> against a tag based security sytsem to get the rights and the to be
>>>> used
>>>> procedure
>>>> for an insert / update / delete. For sure, if no SP was configured for
>>>> the
>>>> user, the insert, delete or save buttons and also dw features where
>>>> automatically
>>>> disabled by the framework.
>>>>
>>>>
>>>> Arnd
>>>>
>>>>
>>>> On 9 Jun 2008 04:44:15 -0700, "Chris Pollach" <cpollach@travel-net.com>
>>>> wrote:
>>>>
>>>>>Hi Louis;
>>>>>
>>>>> You were posed an interesting question! This is how I would do it
>>>>> ...
>>>>>
>>>>>1) Add a computed SQL column (ie: cc_delete)
>>>>>2) Add a filter to the DWO to filter where cc_delete = 'Y'
>>>>>3) When the user requests a Delete - set the computed column to "Y" and
>>>>>it
>>>>>should disappear.
>>>>>
>>>>>When a physical delete is required ... move the filter buffer to the
>>>>>Delete
>>>>>buffer and perform an Update. The interesting bonus behind this
>>>>>approach
>>>>>is
>>>>>to cancel all the pending deletes by just setting the Filter to "" if
>>>>>the
>>>>>user wants to back out of the multi-row delete sequence. :-)
>>>>>
>>>>>HTH
>>>>
>>>
>>>
>>
>


Arnd Schmidt Posted on 2008-06-10 19:48:21.0Z
From: Arnd Schmidt <arnd.schmidt@gmx.de>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Delete rows without moving to delete buffer
Message-ID: <dnlt44tmp50rsi8e62kf3vc2i6a8bmc5pk@4ax.com>
References: <4849515d@forums-1-dub> <48495294.3bcd.1681692777@sybase.com> <484d178f@forums-1-dub> <ud4r44hqstd5i1i1ivrhi02pust5vmibfm@4ax.com> <484d9e74$1@forums-1-dub> <484da09f$1@forums-1-dub> <q7jt44lu4duf0r9kges1h72ailbce4sick@4ax.com> <484ed205$1@forums-1-dub>
X-Newsreader: Forte Agent 1.8/32.548
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 10 Jun 2008 12:48:21 -0700
X-Trace: forums-1-dub 1213127301 10.22.241.152 (10 Jun 2008 12:48:21 -0700)
X-Original-Trace: 10 Jun 2008 12:48:21 -0700, vip152.sybase.com
Lines: 103
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87138
Article PK: 416393

I am glad you also never seen or used this feature ;-)

Also to force a cascading delete when changing the natural key,
is something I have never seen.

Arnd

On 10 Jun 2008 12:12:05 -0700, "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com> wrote:

>I don't believe I ever used the delete/insert option - always synthetic
>keys, so it was never needed.
>Could be the way to go if you needed to cascade delete referential integity
>related rows, which no longer connected because the natural key changed.
>
>"Arnd Schmidt" <arnd.schmidt@gmx.de> wrote in message
>news:q7jt44lu4duf0r9kges1h72ailbce4sick@4ax.com...
>> To allow changing a key column (primary key) was not an option.
>> All PKs were invisible or non editalbe columns for the end user.
>> Also the SPs checked the "generic" last modified user/date informations
>> that has been previously retrieved.
>>
>> Did you see some scenarios where key modification were used in this way
>> (delete / insert)?
>>
>> I am really interested when this could make sense.
>>
>> Arnd
>>
>>
>> On 9 Jun 2008 14:29:03 -0700, "Jerry Siegel [TeamSybase]"
>> <jNOsSPAMsiegel@yahoo!.com> wrote:
>>
>>>Except for a changed key column with the option set to delete and insert
>>>rather than update in place.
>>>
>>>"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com> wrote in message
>>>news:484d9e74$1@forums-1-dub...
>>>> I'm beginning to think it was a trick question! The DW generates a
>>>> delete
>>>> if and only if the row is in the delete buffer, and the only way to get
>>>> around that is to twiddle the SQL in SQLPreview or write your own,
>>>> embedded or in an SP.
>>>>
>>>> "Arnd Schmidt" <arnd.schmidt@gmx.de> wrote in message
>>>> news:ud4r44hqstd5i1i1ivrhi02pust5vmibfm@4ax.com...
>>>>> Because moving rows to the delete buffer will violate the "subject",
>>>>> why not using use a stored procedure-update?
>>>>> The SP deletes the rows in the database where @cc_delete = "Y"
>>>>> and after successfull Update() perform a row discard on cc_delete = "Y"
>>>>> rows
>>>>> in the filter.
>>>>>
>>>>> Maybe the folks had a framework, where they used such an approach.
>>>>>
>>>>> I used a framework where _all_ DB transactions were done via
>>>>> stored procdures, but the framework did not used the built-in DW SP
>>>>> features.
>>>>> Instead there was a repository based service class, that does a match
>>>>> against a tag based security sytsem to get the rights and the to be
>>>>> used
>>>>> procedure
>>>>> for an insert / update / delete. For sure, if no SP was configured for
>>>>> the
>>>>> user, the insert, delete or save buttons and also dw features where
>>>>> automatically
>>>>> disabled by the framework.
>>>>>
>>>>>
>>>>> Arnd
>>>>>
>>>>>
>>>>> On 9 Jun 2008 04:44:15 -0700, "Chris Pollach" <cpollach@travel-net.com>
>>>>> wrote:
>>>>>
>>>>>>Hi Louis;
>>>>>>
>>>>>> You were posed an interesting question! This is how I would do it
>>>>>> ...
>>>>>>
>>>>>>1) Add a computed SQL column (ie: cc_delete)
>>>>>>2) Add a filter to the DWO to filter where cc_delete = 'Y'
>>>>>>3) When the user requests a Delete - set the computed column to "Y" and
>>>>>>it
>>>>>>should disappear.
>>>>>>
>>>>>>When a physical delete is required ... move the filter buffer to the
>>>>>>Delete
>>>>>>buffer and perform an Update. The interesting bonus behind this
>>>>>>approach
>>>>>>is
>>>>>>to cancel all the pending deletes by just setting the Filter to "" if
>>>>>>the
>>>>>>user wants to back out of the multi-row delete sequence. :-)
>>>>>>
>>>>>>HTH
>>>>>
>>>>
>>>>
>>>
>>
>


Chris Pollach Posted on 2008-06-10 11:16:51.0Z
From: "Chris Pollach" <cpollach@travel-net.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4849515d@forums-1-dub> <48495294.3bcd.1681692777@sybase.com> <484d178f@forums-1-dub> <ud4r44hqstd5i1i1ivrhi02pust5vmibfm@4ax.com>
Subject: Re: Delete rows without moving to delete buffer
Lines: 52
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: <484e62a3@forums-1-dub>
Date: 10 Jun 2008 04:16:51 -0700
X-Trace: forums-1-dub 1213096611 10.22.241.152 (10 Jun 2008 04:16:51 -0700)
X-Original-Trace: 10 Jun 2008 04:16:51 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87131
Article PK: 416387

As long as you never move DBMS engines - that approach is a good one! :-)

"Arnd Schmidt" <arnd.schmidt@gmx.de> wrote in message
news:ud4r44hqstd5i1i1ivrhi02pust5vmibfm@4ax.com...
> Because moving rows to the delete buffer will violate the "subject",
> why not using use a stored procedure-update?
> The SP deletes the rows in the database where @cc_delete = "Y"
> and after successfull Update() perform a row discard on cc_delete = "Y"
> rows
> in the filter.
>
> Maybe the folks had a framework, where they used such an approach.
>
> I used a framework where _all_ DB transactions were done via
> stored procdures, but the framework did not used the built-in DW SP
> features.
> Instead there was a repository based service class, that does a match
> against a tag based security sytsem to get the rights and the to be used
> procedure
> for an insert / update / delete. For sure, if no SP was configured for the
> user, the insert, delete or save buttons and also dw features where
> automatically
> disabled by the framework.
>
>
> Arnd
>
>
> On 9 Jun 2008 04:44:15 -0700, "Chris Pollach" <cpollach@travel-net.com>
> wrote:
>
>>Hi Louis;
>>
>> You were posed an interesting question! This is how I would do it ...
>>
>>1) Add a computed SQL column (ie: cc_delete)
>>2) Add a filter to the DWO to filter where cc_delete = 'Y'
>>3) When the user requests a Delete - set the computed column to "Y" and it
>>should disappear.
>>
>>When a physical delete is required ... move the filter buffer to the
>>Delete
>>buffer and perform an Update. The interesting bonus behind this approach
>>is
>>to cancel all the pending deletes by just setting the Filter to "" if the
>>user wants to back out of the multi-row delete sequence. :-)
>>
>>HTH
>