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 and buffers

6 posts in DataWindow Last posting was on 2008-05-26 13:47:09.0Z
CarolD Posted on 2008-05-23 15:05:00.0Z
From: "CarolD" <clc@css.ncifcrf.gov>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: update and buffers
Lines: 20
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1914
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1914
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4836dd1c@forums-1-dub>
Date: 23 May 2008 08:05:00 -0700
X-Trace: forums-1-dub 1211555100 10.22.241.152 (23 May 2008 08:05:00 -0700)
X-Original-Trace: 23 May 2008 08:05:00 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86935
Article PK: 416192

I seem to be having a case where rows are saved to my table when I think
they are in the filter buffer. Is there any case where this would be
happening?

my procedure is this.
I insert rows as necessary into a datastore
when finished I use rowscopy to copy those rows to my primary dw dw_data

then I filter dw_data for a particular data item. so there are many of these
new rows in dw_data that are now in the filter buffer.

I update rows I see in my primary buffer as necessary and use dw_data.update
the rows I don't see that I believe are in the filter buffer are saved also.
I would not expect this to happen.

any suggestions as to what is happening or why these rows would be saved.

Thanks


"Jason 'Bug' Fenter [TeamSybase]" <NO_SPAMMING_jason.fenter_ Posted on 2008-05-23 15:16:41.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: update and buffers
References: <4836dd1c@forums-1-dub>
In-Reply-To: <4836dd1c@forums-1-dub>
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: <4836dfd9$1@forums-1-dub>
Date: 23 May 2008 08:16:41 -0700
X-Trace: forums-1-dub 1211555801 10.22.241.152 (23 May 2008 08:16:41 -0700)
X-Original-Trace: 23 May 2008 08:16:41 -0700, vip152.sybase.com
Lines: 27
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86936
Article PK: 416193

Yes, this is normal and desired behavior for a DataWindow / DataStore.
If you want to get rid of rows without deleting them from the database,
use RowsDiscard().

CarolD wrote:
> I seem to be having a case where rows are saved to my table when I think
> they are in the filter buffer. Is there any case where this would be
> happening?
>
> my procedure is this.
> I insert rows as necessary into a datastore
> when finished I use rowscopy to copy those rows to my primary dw dw_data
>
> then I filter dw_data for a particular data item. so there are many of these
> new rows in dw_data that are now in the filter buffer.
>
> I update rows I see in my primary buffer as necessary and use dw_data.update
> the rows I don't see that I believe are in the filter buffer are saved also.
> I would not expect this to happen.
>
> any suggestions as to what is happening or why these rows would be saved.
>
> Thanks
>
>


Ed Van Haren Posted on 2008-05-23 15:18:43.0Z
From: "Ed Van Haren" <ed.VanHaren@worksafebc.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4836dd1c@forums-1-dub>
Subject: Re: update and buffers
Lines: 34
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: <4836e053$1@forums-1-dub>
Date: 23 May 2008 08:18:43 -0700
X-Trace: forums-1-dub 1211555923 10.22.241.152 (23 May 2008 08:18:43 -0700)
X-Original-Trace: 23 May 2008 08:18:43 -0700, vip152.sybase.com
X-Authenticated-User: pb110beta
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86937
Article PK: 416194

Update applies to the whole datawindow including the Filter buffer. The
primary buffer is just what is displayed. When you call the update, all rows
are processed as per their flags (New!, NewModified!, NotModified,
DataModified!). The update will insert NewModified rows, update DataModified
rows and delete rows in the deleted buffer.

"CarolD" <clc@css.ncifcrf.gov> wrote in message
news:4836dd1c@forums-1-dub...
>I seem to be having a case where rows are saved to my table when I think
> they are in the filter buffer. Is there any case where this would be
> happening?
>
> my procedure is this.
> I insert rows as necessary into a datastore
> when finished I use rowscopy to copy those rows to my primary dw dw_data
>
> then I filter dw_data for a particular data item. so there are many of
> these
> new rows in dw_data that are now in the filter buffer.
>
> I update rows I see in my primary buffer as necessary and use
> dw_data.update
> the rows I don't see that I believe are in the filter buffer are saved
> also.
> I would not expect this to happen.
>
> any suggestions as to what is happening or why these rows would be saved.
>
> Thanks
>
>


CarolD Posted on 2008-05-23 20:36:32.0Z
From: "CarolD" <clc@css.ncifcrf.gov>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4836dd1c@forums-1-dub> <4836e053$1@forums-1-dub>
Subject: Re: update and buffers
Lines: 46
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1914
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1914
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48372ad0$1@forums-1-dub>
Date: 23 May 2008 13:36:32 -0700
X-Trace: forums-1-dub 1211574992 10.22.241.152 (23 May 2008 13:36:32 -0700)
X-Original-Trace: 23 May 2008 13:36:32 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86948
Article PK: 416205

if i wanted to set a value in a column in a row that is in the filter buffer
can I do that or do I have to bring it back to the primary buffer before
issuing the dw_data.SetItem...

"Ed Van Haren" <ed.VanHaren@worksafebc.com> wrote in message
news:4836e053$1@forums-1-dub...
> Update applies to the whole datawindow including the Filter buffer. The
> primary buffer is just what is displayed. When you call the update, all
rows
> are processed as per their flags (New!, NewModified!, NotModified,
> DataModified!). The update will insert NewModified rows, update
DataModified
> rows and delete rows in the deleted buffer.
>
>
> "CarolD" <clc@css.ncifcrf.gov> wrote in message
> news:4836dd1c@forums-1-dub...
> >I seem to be having a case where rows are saved to my table when I think
> > they are in the filter buffer. Is there any case where this would be
> > happening?
> >
> > my procedure is this.
> > I insert rows as necessary into a datastore
> > when finished I use rowscopy to copy those rows to my primary dw dw_data
> >
> > then I filter dw_data for a particular data item. so there are many of
> > these
> > new rows in dw_data that are now in the filter buffer.
> >
> > I update rows I see in my primary buffer as necessary and use
> > dw_data.update
> > the rows I don't see that I believe are in the filter buffer are saved
> > also.
> > I would not expect this to happen.
> >
> > any suggestions as to what is happening or why these rows would be
saved.
> >
> > Thanks
> >
> >
>
>


"Jason 'Bug' Fenter [TeamSybase]" <NO_SPAMMING_jason.fenter_ Posted on 2008-05-23 20:53:18.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: update and buffers
References: <4836dd1c@forums-1-dub> <4836e053$1@forums-1-dub> <48372ad0$1@forums-1-dub>
In-Reply-To: <48372ad0$1@forums-1-dub>
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: <48372ebe$1@forums-1-dub>
Date: 23 May 2008 13:53:18 -0700
X-Trace: forums-1-dub 1211575998 10.22.241.152 (23 May 2008 13:53:18 -0700)
X-Original-Trace: 23 May 2008 13:53:18 -0700, vip152.sybase.com
Lines: 49
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86949
Article PK: 416207

SetItem does not allow you to specify the buffer. However, you can use
dot notation to get to any buffer.

CarolD wrote:
> if i wanted to set a value in a column in a row that is in the filter buffer
> can I do that or do I have to bring it back to the primary buffer before
> issuing the dw_data.SetItem...
>
>
> "Ed Van Haren" <ed.VanHaren@worksafebc.com> wrote in message
> news:4836e053$1@forums-1-dub...
>> Update applies to the whole datawindow including the Filter buffer. The
>> primary buffer is just what is displayed. When you call the update, all
> rows
>> are processed as per their flags (New!, NewModified!, NotModified,
>> DataModified!). The update will insert NewModified rows, update
> DataModified
>> rows and delete rows in the deleted buffer.
>>
>>
>> "CarolD" <clc@css.ncifcrf.gov> wrote in message
>> news:4836dd1c@forums-1-dub...
>>> I seem to be having a case where rows are saved to my table when I think
>>> they are in the filter buffer. Is there any case where this would be
>>> happening?
>>>
>>> my procedure is this.
>>> I insert rows as necessary into a datastore
>>> when finished I use rowscopy to copy those rows to my primary dw dw_data
>>>
>>> then I filter dw_data for a particular data item. so there are many of
>>> these
>>> new rows in dw_data that are now in the filter buffer.
>>>
>>> I update rows I see in my primary buffer as necessary and use
>>> dw_data.update
>>> the rows I don't see that I believe are in the filter buffer are saved
>>> also.
>>> I would not expect this to happen.
>>>
>>> any suggestions as to what is happening or why these rows would be
> saved.
>>> Thanks
>>>
>>>
>>
>
>


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2008-05-26 13:47:09.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4836dd1c@forums-1-dub> <4836e053$1@forums-1-dub> <48372ad0$1@forums-1-dub> <48372ebe$1@forums-1-dub>
Subject: Re: update and buffers
Lines: 57
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: <483abf5d$1@forums-1-dub>
Date: 26 May 2008 06:47:09 -0700
X-Trace: forums-1-dub 1211809629 10.22.241.152 (26 May 2008 06:47:09 -0700)
X-Original-Trace: 26 May 2008 06:47:09 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86953
Article PK: 416210

Enhancement request 2495 has been there since 2005! Vote early and often!

"Jason 'Bug' Fenter [TeamSybase]"

<NO_SPAMMING_jason.fenter_@_teamsybase.com> wrote in message
news:48372ebe$1@forums-1-dub...
> SetItem does not allow you to specify the buffer. However, you can use dot
> notation to get to any buffer.
>
>
> CarolD wrote:
>> if i wanted to set a value in a column in a row that is in the filter
>> buffer
>> can I do that or do I have to bring it back to the primary buffer before
>> issuing the dw_data.SetItem...
>>
>>
>> "Ed Van Haren" <ed.VanHaren@worksafebc.com> wrote in message
>> news:4836e053$1@forums-1-dub...
>>> Update applies to the whole datawindow including the Filter buffer. The
>>> primary buffer is just what is displayed. When you call the update, all
>> rows
>>> are processed as per their flags (New!, NewModified!, NotModified,
>>> DataModified!). The update will insert NewModified rows, update
>> DataModified
>>> rows and delete rows in the deleted buffer.
>>>
>>>
>>> "CarolD" <clc@css.ncifcrf.gov> wrote in message
>>> news:4836dd1c@forums-1-dub...
>>>> I seem to be having a case where rows are saved to my table when I
>>>> think
>>>> they are in the filter buffer. Is there any case where this would be
>>>> happening?
>>>>
>>>> my procedure is this.
>>>> I insert rows as necessary into a datastore
>>>> when finished I use rowscopy to copy those rows to my primary dw
>>>> dw_data
>>>>
>>>> then I filter dw_data for a particular data item. so there are many of
>>>> these
>>>> new rows in dw_data that are now in the filter buffer.
>>>>
>>>> I update rows I see in my primary buffer as necessary and use
>>>> dw_data.update
>>>> the rows I don't see that I believe are in the filter buffer are saved
>>>> also.
>>>> I would not expect this to happen.
>>>>
>>>> any suggestions as to what is happening or why these rows would be
>> saved.
>>>> Thanks
>>>>
>>>>
>>>
>>