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.

Find() in the Filtered Buffer

12 posts in DataWindow Last posting was on 2009-04-29 11:38:37.0Z
Jason Lipman Posted on 2009-03-20 15:43:32.0Z
From: "Jason Lipman" <NOSPAM-jlipman@oppenheimer>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Find() in the Filtered Buffer
Lines: 19
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.3350
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49c3b9a4$1@forums-1-dub>
Date: 20 Mar 2009 07:43:32 -0800
X-Trace: forums-1-dub 1237563812 10.22.241.152 (20 Mar 2009 07:43:32 -0800)
X-Original-Trace: 20 Mar 2009 07:43:32 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89020
Article PK: 418269

PB 10.5.2

I thought there was syntax, but cannot find it...

Before saving a datawindow, I am validating a new row to ensure the Primary
Key is not being used again. However, the possible dup could be in the
Filtered buffer.

Is there a way to use Find() against anything other than the default
Primary! buffer? Is there a better option? I am hoping I do not need to move
all the data into a Datastore, as Primary Buffer, to solve this.

IE: Is something like this possible... Find(" column.filtered = '123' ")

Thank you,
Jason Lipman


Chris Pollach Posted on 2009-03-20 16:33:30.0Z
From: "Chris Pollach" <cpollach@travel-net.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <49c3b9a4$1@forums-1-dub>
Subject: Re: Find() in the Filtered Buffer
Lines: 49
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.5579
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49c3c55a$1@forums-1-dub>
Date: 20 Mar 2009 08:33:30 -0800
X-Trace: forums-1-dub 1237566810 10.22.241.152 (20 Mar 2009 08:33:30 -0800)
X-Original-Trace: 20 Mar 2009 08:33:30 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89022
Article PK: 418272

Hi Jason;

I think that you have basically two choices:

1) Drop the Filter - do the Find - then reinstate the Fillter.
- or -
2) Copy the current filter buffer on the DC to a DataStore and then do a
Find on the DS's primary buffer.
for example ...

DataStore lo_ds
lo_ds = Create DataStore
lo_ds.DataObject = DC.DataObject
DC.RowsCopy (1, DC.RowCount ( ), Filter!, lo_ds, 1, Primary!)

lo_ds.Find ( ls_your_criteria)


HTH

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

"Jason Lipman" <NOSPAM-jlipman@oppenheimer> wrote in message
news:49c3b9a4$1@forums-1-dub...
> PB 10.5.2
>
> I thought there was syntax, but cannot find it...
>
> Before saving a datawindow, I am validating a new row to ensure the
> Primary Key is not being used again. However, the possible dup could be in
> the Filtered buffer.
>
> Is there a way to use Find() against anything other than the default
> Primary! buffer? Is there a better option? I am hoping I do not need to
> move all the data into a Datastore, as Primary Buffer, to solve this.
>
> IE: Is something like this possible... Find(" column.filtered = '123' ")
>
> Thank you,
> Jason Lipman
>
>
>


Jason Lipman Posted on 2009-03-20 16:51:56.0Z
From: "Jason Lipman" <NOSPAM-jlipman@oppenheimer>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <49c3b9a4$1@forums-1-dub> <49c3c55a$1@forums-1-dub>
Subject: Re: Find() in the Filtered Buffer
Lines: 62
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.3350
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49c3c9ac$1@forums-1-dub>
Date: 20 Mar 2009 08:51:56 -0800
X-Trace: forums-1-dub 1237567916 10.22.241.152 (20 Mar 2009 08:51:56 -0800)
X-Original-Trace: 20 Mar 2009 08:51:56 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89025
Article PK: 418274

Chris,

Yup,

Thank is sort'a what I thought would be the case. Adding a filter argument
to thd Find function would be a great enhancement idea for Sybase. I'll get
into ISUG and submit it!

"Chris Pollach" <cpollach@travel-net.com> wrote in message
news:49c3c55a$1@forums-1-dub...
> Hi Jason;
>
> I think that you have basically two choices:
>
> 1) Drop the Filter - do the Find - then reinstate the Fillter.
> - or -
> 2) Copy the current filter buffer on the DC to a DataStore and then do a
> Find on the DS's primary buffer.
> for example ...
>
> DataStore lo_ds
> lo_ds = Create DataStore
> lo_ds.DataObject = DC.DataObject
> DC.RowsCopy (1, DC.RowCount ( ), Filter!, lo_ds, 1, Primary!)
>
> lo_ds.Find ( ls_your_criteria)
>
>
> HTH
>
> --
> Regards ... Chris
> ISUG - NA RUG Director
> http://chrispollach.pbdjmagazine.com
>
>
> "Jason Lipman" <NOSPAM-jlipman@oppenheimer> wrote in message
> news:49c3b9a4$1@forums-1-dub...
>> PB 10.5.2
>>
>> I thought there was syntax, but cannot find it...
>>
>> Before saving a datawindow, I am validating a new row to ensure the
>> Primary Key is not being used again. However, the possible dup could be
>> in the Filtered buffer.
>>
>> Is there a way to use Find() against anything other than the default
>> Primary! buffer? Is there a better option? I am hoping I do not need to
>> move all the data into a Datastore, as Primary Buffer, to solve this.
>>
>> IE: Is something like this possible... Find(" column.filtered = '123' ")
>>
>> Thank you,
>> Jason Lipman
>>
>>
>>
>
>


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2009-03-20 17:48:19.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <49c3b9a4$1@forums-1-dub> <49c3c55a$1@forums-1-dub> <49c3c9ac$1@forums-1-dub>
Subject: Re: Find() in the Filtered Buffer
Lines: 79
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49c3d6e3@forums-1-dub>
Date: 20 Mar 2009 09:48:19 -0800
X-Trace: forums-1-dub 1237571299 10.22.241.152 (20 Mar 2009 09:48:19 -0800)
X-Original-Trace: 20 Mar 2009 09:48:19 -0800, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89028
Article PK: 418277

I have suggested that in a TW session with engineering - add an optional
buffer argument to Find and Sort, defaults to Primary! so it doesn't break
existing code. Should also be able to work on Delete! buffer.

Post the enhancement # and I'll vote for it.

And I've used that same workaround :-(

--
Report Bugs: http://case-express.sybase.com/cx/welcome.do
Product Enhancement Requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement

"Jason Lipman" <NOSPAM-jlipman@oppenheimer> wrote in message
news:49c3c9ac$1@forums-1-dub...
> Chris,
>
> Yup,
>
> Thank is sort'a what I thought would be the case. Adding a filter argument
> to thd Find function would be a great enhancement idea for Sybase. I'll
> get into ISUG and submit it!
>
>
> "Chris Pollach" <cpollach@travel-net.com> wrote in message
> news:49c3c55a$1@forums-1-dub...
>> Hi Jason;
>>
>> I think that you have basically two choices:
>>
>> 1) Drop the Filter - do the Find - then reinstate the Fillter.
>> - or -
>> 2) Copy the current filter buffer on the DC to a DataStore and then do a
>> Find on the DS's primary buffer.
>> for example ...
>>
>> DataStore lo_ds
>> lo_ds = Create DataStore
>> lo_ds.DataObject = DC.DataObject
>> DC.RowsCopy (1, DC.RowCount ( ), Filter!, lo_ds, 1, Primary!)
>>
>> lo_ds.Find ( ls_your_criteria)
>>
>>
>> HTH
>>
>> --
>> Regards ... Chris
>> ISUG - NA RUG Director
>> http://chrispollach.pbdjmagazine.com
>>
>>
>> "Jason Lipman" <NOSPAM-jlipman@oppenheimer> wrote in message
>> news:49c3b9a4$1@forums-1-dub...
>>> PB 10.5.2
>>>
>>> I thought there was syntax, but cannot find it...
>>>
>>> Before saving a datawindow, I am validating a new row to ensure the
>>> Primary Key is not being used again. However, the possible dup could be
>>> in the Filtered buffer.
>>>
>>> Is there a way to use Find() against anything other than the default
>>> Primary! buffer? Is there a better option? I am hoping I do not need to
>>> move all the data into a Datastore, as Primary Buffer, to solve this.
>>>
>>> IE: Is something like this possible... Find(" column.filtered = '123' ")
>>>
>>> Thank you,
>>> Jason Lipman
>>>
>>>
>>>
>>
>>
>
>


Roland Smith [TeamSybase] Posted on 2009-03-20 19:15:35.0Z
From: "Roland Smith [TeamSybase]" <rsmith_at_trusthss_dot_com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <49c3b9a4$1@forums-1-dub> <49c3c55a$1@forums-1-dub> <49c3c9ac$1@forums-1-dub> <49c3d6e3@forums-1-dub>
Subject: Re: Find() in the Filtered Buffer
Lines: 88
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49c3eb57$1@forums-1-dub>
Date: 20 Mar 2009 11:15:35 -0800
X-Trace: forums-1-dub 1237576535 10.22.241.152 (20 Mar 2009 11:15:35 -0800)
X-Original-Trace: 20 Mar 2009 11:15:35 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89030
Article PK: 418282

I've always looped thru the filtered rows and used the optional Buffer
argument to the GetItemXxxx functions to manually search. Having an optional
Buffer arg to Find would be great.

"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com> wrote in message
news:49c3d6e3@forums-1-dub...
>I have suggested that in a TW session with engineering - add an optional
>buffer argument to Find and Sort, defaults to Primary! so it doesn't break
>existing code. Should also be able to work on Delete! buffer.
>
> Post the enhancement # and I'll vote for it.
>
> And I've used that same workaround :-(
>
> --
> Report Bugs: http://case-express.sybase.com/cx/welcome.do
> Product Enhancement Requests:
> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>
> "Jason Lipman" <NOSPAM-jlipman@oppenheimer> wrote in message
> news:49c3c9ac$1@forums-1-dub...
>> Chris,
>>
>> Yup,
>>
>> Thank is sort'a what I thought would be the case. Adding a filter
>> argument to thd Find function would be a great enhancement idea for
>> Sybase. I'll get into ISUG and submit it!
>>
>>
>> "Chris Pollach" <cpollach@travel-net.com> wrote in message
>> news:49c3c55a$1@forums-1-dub...
>>> Hi Jason;
>>>
>>> I think that you have basically two choices:
>>>
>>> 1) Drop the Filter - do the Find - then reinstate the Fillter.
>>> - or -
>>> 2) Copy the current filter buffer on the DC to a DataStore and then do a
>>> Find on the DS's primary buffer.
>>> for example ...
>>>
>>> DataStore lo_ds
>>> lo_ds = Create DataStore
>>> lo_ds.DataObject = DC.DataObject
>>> DC.RowsCopy (1, DC.RowCount ( ), Filter!, lo_ds, 1, Primary!)
>>>
>>> lo_ds.Find ( ls_your_criteria)
>>>
>>>
>>> HTH
>>>
>>> --
>>> Regards ... Chris
>>> ISUG - NA RUG Director
>>> http://chrispollach.pbdjmagazine.com
>>>
>>>
>>> "Jason Lipman" <NOSPAM-jlipman@oppenheimer> wrote in message
>>> news:49c3b9a4$1@forums-1-dub...
>>>> PB 10.5.2
>>>>
>>>> I thought there was syntax, but cannot find it...
>>>>
>>>> Before saving a datawindow, I am validating a new row to ensure the
>>>> Primary Key is not being used again. However, the possible dup could be
>>>> in the Filtered buffer.
>>>>
>>>> Is there a way to use Find() against anything other than the default
>>>> Primary! buffer? Is there a better option? I am hoping I do not need to
>>>> move all the data into a Datastore, as Primary Buffer, to solve this.
>>>>
>>>> IE: Is something like this possible... Find(" column.filtered = '123'
>>>> ")
>>>>
>>>> Thank you,
>>>> Jason Lipman
>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2009-03-20 19:26:10.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <49c3b9a4$1@forums-1-dub> <49c3c55a$1@forums-1-dub> <49c3c9ac$1@forums-1-dub> <49c3d6e3@forums-1-dub> <49c3eb57$1@forums-1-dub>
Subject: Re: Find() in the Filtered Buffer
Lines: 103
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49c3edd2$1@forums-1-dub>
Date: 20 Mar 2009 11:26:10 -0800
X-Trace: forums-1-dub 1237577170 10.22.241.152 (20 Mar 2009 11:26:10 -0800)
X-Original-Trace: 20 Mar 2009 11:26:10 -0800, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89031
Article PK: 418285

Since Find runs in the compiled C within the DW engine, I'd expect it to be
more efficient. OTOH, unless there are more rows that you really ought to
have on the client the difference is unlikely to be perceptible to carbon
based life forms.

--
Report Bugs: http://case-express.sybase.com/cx/welcome.do
Product Enhancement Requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement

"Roland Smith [TeamSybase]" <rsmith_at_trusthss_dot_com> wrote in message
news:49c3eb57$1@forums-1-dub...
> I've always looped thru the filtered rows and used the optional Buffer
> argument to the GetItemXxxx functions to manually search. Having an
> optional Buffer arg to Find would be great.
>
> "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com> wrote in message
> news:49c3d6e3@forums-1-dub...
>>I have suggested that in a TW session with engineering - add an optional
>>buffer argument to Find and Sort, defaults to Primary! so it doesn't break
>>existing code. Should also be able to work on Delete! buffer.
>>
>> Post the enhancement # and I'll vote for it.
>>
>> And I've used that same workaround :-(
>>
>> --
>> Report Bugs: http://case-express.sybase.com/cx/welcome.do
>> Product Enhancement Requests:
>> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>>
>> "Jason Lipman" <NOSPAM-jlipman@oppenheimer> wrote in message
>> news:49c3c9ac$1@forums-1-dub...
>>> Chris,
>>>
>>> Yup,
>>>
>>> Thank is sort'a what I thought would be the case. Adding a filter
>>> argument to thd Find function would be a great enhancement idea for
>>> Sybase. I'll get into ISUG and submit it!
>>>
>>>
>>> "Chris Pollach" <cpollach@travel-net.com> wrote in message
>>> news:49c3c55a$1@forums-1-dub...
>>>> Hi Jason;
>>>>
>>>> I think that you have basically two choices:
>>>>
>>>> 1) Drop the Filter - do the Find - then reinstate the Fillter.
>>>> - or -
>>>> 2) Copy the current filter buffer on the DC to a DataStore and then do
>>>> a Find on the DS's primary buffer.
>>>> for example ...
>>>>
>>>> DataStore lo_ds
>>>> lo_ds = Create DataStore
>>>> lo_ds.DataObject = DC.DataObject
>>>> DC.RowsCopy (1, DC.RowCount ( ), Filter!, lo_ds, 1, Primary!)
>>>>
>>>> lo_ds.Find ( ls_your_criteria)
>>>>
>>>>
>>>> HTH
>>>>
>>>> --
>>>> Regards ... Chris
>>>> ISUG - NA RUG Director
>>>> http://chrispollach.pbdjmagazine.com
>>>>
>>>>
>>>> "Jason Lipman" <NOSPAM-jlipman@oppenheimer> wrote in message
>>>> news:49c3b9a4$1@forums-1-dub...
>>>>> PB 10.5.2
>>>>>
>>>>> I thought there was syntax, but cannot find it...
>>>>>
>>>>> Before saving a datawindow, I am validating a new row to ensure the
>>>>> Primary Key is not being used again. However, the possible dup could
>>>>> be in the Filtered buffer.
>>>>>
>>>>> Is there a way to use Find() against anything other than the default
>>>>> Primary! buffer? Is there a better option? I am hoping I do not need
>>>>> to move all the data into a Datastore, as Primary Buffer, to solve
>>>>> this.
>>>>>
>>>>> IE: Is something like this possible... Find(" column.filtered = '123'
>>>>> ")
>>>>>
>>>>> Thank you,
>>>>> Jason Lipman
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>


Jason Lipman Posted on 2009-03-30 16:21:47.0Z
From: "Jason Lipman" <NOSPAM-jlipman@oppenheimer>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <49c3b9a4$1@forums-1-dub> <49c3c55a$1@forums-1-dub> <49c3c9ac$1@forums-1-dub> <49c3d6e3@forums-1-dub> <49c3eb57$1@forums-1-dub> <49c3edd2$1@forums-1-dub>
Subject: Re: Find() in the Filtered Buffer
Lines: 110
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.3350
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49d0f19b$1@forums-1-dub>
Date: 30 Mar 2009 08:21:47 -0800
X-Trace: forums-1-dub 1238430107 10.22.241.152 (30 Mar 2009 08:21:47 -0800)
X-Original-Trace: 30 Mar 2009 08:21:47 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89062
Article PK: 418314

Enhancement was accepted at ISUG. - Jason

"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com> wrote in message
news:49c3edd2$1@forums-1-dub...
> Since Find runs in the compiled C within the DW engine, I'd expect it to
> be more efficient. OTOH, unless there are more rows that you really ought
> to have on the client the difference is unlikely to be perceptible to
> carbon based life forms.
>
> --
> Report Bugs: http://case-express.sybase.com/cx/welcome.do
> Product Enhancement Requests:
> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>
> "Roland Smith [TeamSybase]" <rsmith_at_trusthss_dot_com> wrote in message
> news:49c3eb57$1@forums-1-dub...
>> I've always looped thru the filtered rows and used the optional Buffer
>> argument to the GetItemXxxx functions to manually search. Having an
>> optional Buffer arg to Find would be great.
>>
>> "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com> wrote in message
>> news:49c3d6e3@forums-1-dub...
>>>I have suggested that in a TW session with engineering - add an optional
>>>buffer argument to Find and Sort, defaults to Primary! so it doesn't
>>>break existing code. Should also be able to work on Delete! buffer.
>>>
>>> Post the enhancement # and I'll vote for it.
>>>
>>> And I've used that same workaround :-(
>>>
>>> --
>>> Report Bugs: http://case-express.sybase.com/cx/welcome.do
>>> Product Enhancement Requests:
>>> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>>>
>>> "Jason Lipman" <NOSPAM-jlipman@oppenheimer> wrote in message
>>> news:49c3c9ac$1@forums-1-dub...
>>>> Chris,
>>>>
>>>> Yup,
>>>>
>>>> Thank is sort'a what I thought would be the case. Adding a filter
>>>> argument to thd Find function would be a great enhancement idea for
>>>> Sybase. I'll get into ISUG and submit it!
>>>>
>>>>
>>>> "Chris Pollach" <cpollach@travel-net.com> wrote in message
>>>> news:49c3c55a$1@forums-1-dub...
>>>>> Hi Jason;
>>>>>
>>>>> I think that you have basically two choices:
>>>>>
>>>>> 1) Drop the Filter - do the Find - then reinstate the Fillter.
>>>>> - or -
>>>>> 2) Copy the current filter buffer on the DC to a DataStore and then do
>>>>> a Find on the DS's primary buffer.
>>>>> for example ...
>>>>>
>>>>> DataStore lo_ds
>>>>> lo_ds = Create DataStore
>>>>> lo_ds.DataObject = DC.DataObject
>>>>> DC.RowsCopy (1, DC.RowCount ( ), Filter!, lo_ds, 1, Primary!)
>>>>>
>>>>> lo_ds.Find ( ls_your_criteria)
>>>>>
>>>>>
>>>>> HTH
>>>>>
>>>>> --
>>>>> Regards ... Chris
>>>>> ISUG - NA RUG Director
>>>>> http://chrispollach.pbdjmagazine.com
>>>>>
>>>>>
>>>>> "Jason Lipman" <NOSPAM-jlipman@oppenheimer> wrote in message
>>>>> news:49c3b9a4$1@forums-1-dub...
>>>>>> PB 10.5.2
>>>>>>
>>>>>> I thought there was syntax, but cannot find it...
>>>>>>
>>>>>> Before saving a datawindow, I am validating a new row to ensure the
>>>>>> Primary Key is not being used again. However, the possible dup could
>>>>>> be in the Filtered buffer.
>>>>>>
>>>>>> Is there a way to use Find() against anything other than the default
>>>>>> Primary! buffer? Is there a better option? I am hoping I do not need
>>>>>> to move all the data into a Datastore, as Primary Buffer, to solve
>>>>>> this.
>>>>>>
>>>>>> IE: Is something like this possible... Find(" column.filtered = '123'
>>>>>> ")
>>>>>>
>>>>>> Thank you,
>>>>>> Jason Lipman
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2009-03-30 19:09:31.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <49c3b9a4$1@forums-1-dub> <49c3c55a$1@forums-1-dub> <49c3c9ac$1@forums-1-dub> <49c3d6e3@forums-1-dub> <49c3eb57$1@forums-1-dub> <49c3edd2$1@forums-1-dub> <49d0f19b$1@forums-1-dub>
Subject: Re: Find() in the Filtered Buffer
Lines: 121
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.5579
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49d118eb$1@forums-1-dub>
Date: 30 Mar 2009 11:09:31 -0800
X-Trace: forums-1-dub 1238440171 10.22.241.152 (30 Mar 2009 11:09:31 -0800)
X-Original-Trace: 30 Mar 2009 11:09:31 -0800, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89064
Article PK: 418316

That's #3571 - vote early and often!

--
Report Bugs: http://case-express.sybase.com/cx/welcome.do
Product Enhancement Requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement

"Jason Lipman" <NOSPAM-jlipman@oppenheimer> wrote in message
news:49d0f19b$1@forums-1-dub...
> Enhancement was accepted at ISUG. - Jason
>
>
> "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com> wrote in message
> news:49c3edd2$1@forums-1-dub...
>> Since Find runs in the compiled C within the DW engine, I'd expect it to
>> be more efficient. OTOH, unless there are more rows that you really ought
>> to have on the client the difference is unlikely to be perceptible to
>> carbon based life forms.
>>
>> --
>> Report Bugs: http://case-express.sybase.com/cx/welcome.do
>> Product Enhancement Requests:
>> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>>
>> "Roland Smith [TeamSybase]" <rsmith_at_trusthss_dot_com> wrote in message
>> news:49c3eb57$1@forums-1-dub...
>>> I've always looped thru the filtered rows and used the optional Buffer
>>> argument to the GetItemXxxx functions to manually search. Having an
>>> optional Buffer arg to Find would be great.
>>>
>>> "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com> wrote in message
>>> news:49c3d6e3@forums-1-dub...
>>>>I have suggested that in a TW session with engineering - add an optional
>>>>buffer argument to Find and Sort, defaults to Primary! so it doesn't
>>>>break existing code. Should also be able to work on Delete! buffer.
>>>>
>>>> Post the enhancement # and I'll vote for it.
>>>>
>>>> And I've used that same workaround :-(
>>>>
>>>> --
>>>> Report Bugs: http://case-express.sybase.com/cx/welcome.do
>>>> Product Enhancement Requests:
>>>> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>>>>
>>>> "Jason Lipman" <NOSPAM-jlipman@oppenheimer> wrote in message
>>>> news:49c3c9ac$1@forums-1-dub...
>>>>> Chris,
>>>>>
>>>>> Yup,
>>>>>
>>>>> Thank is sort'a what I thought would be the case. Adding a filter
>>>>> argument to thd Find function would be a great enhancement idea for
>>>>> Sybase. I'll get into ISUG and submit it!
>>>>>
>>>>>
>>>>> "Chris Pollach" <cpollach@travel-net.com> wrote in message
>>>>> news:49c3c55a$1@forums-1-dub...
>>>>>> Hi Jason;
>>>>>>
>>>>>> I think that you have basically two choices:
>>>>>>
>>>>>> 1) Drop the Filter - do the Find - then reinstate the Fillter.
>>>>>> - or -
>>>>>> 2) Copy the current filter buffer on the DC to a DataStore and then
>>>>>> do a Find on the DS's primary buffer.
>>>>>> for example ...
>>>>>>
>>>>>> DataStore lo_ds
>>>>>> lo_ds = Create DataStore
>>>>>> lo_ds.DataObject = DC.DataObject
>>>>>> DC.RowsCopy (1, DC.RowCount ( ), Filter!, lo_ds, 1, Primary!)
>>>>>>
>>>>>> lo_ds.Find ( ls_your_criteria)
>>>>>>
>>>>>>
>>>>>> HTH
>>>>>>
>>>>>> --
>>>>>> Regards ... Chris
>>>>>> ISUG - NA RUG Director
>>>>>> http://chrispollach.pbdjmagazine.com
>>>>>>
>>>>>>
>>>>>> "Jason Lipman" <NOSPAM-jlipman@oppenheimer> wrote in message
>>>>>> news:49c3b9a4$1@forums-1-dub...
>>>>>>> PB 10.5.2
>>>>>>>
>>>>>>> I thought there was syntax, but cannot find it...
>>>>>>>
>>>>>>> Before saving a datawindow, I am validating a new row to ensure the
>>>>>>> Primary Key is not being used again. However, the possible dup could
>>>>>>> be in the Filtered buffer.
>>>>>>>
>>>>>>> Is there a way to use Find() against anything other than the default
>>>>>>> Primary! buffer? Is there a better option? I am hoping I do not need
>>>>>>> to move all the data into a Datastore, as Primary Buffer, to solve
>>>>>>> this.
>>>>>>>
>>>>>>> IE: Is something like this possible... Find(" column.filtered =
>>>>>>> '123' ")
>>>>>>>
>>>>>>> Thank you,
>>>>>>> Jason Lipman
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>


Jeremy Lakeman Posted on 2009-03-21 07:22:40.0Z
From: Jeremy Lakeman <jeremy.lakeman@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Find() in the Filtered Buffer
Date: Sat, 21 Mar 2009 00:22:40 -0700 (PDT)
Organization: http://groups.google.com
Lines: 83
Message-ID: <d1eb3958-c3f7-48dc-a811-050a1ea603c9@j9g2000prh.googlegroups.com>
References: <49c3b9a4$1@forums-1-dub> <49c3c55a$1@forums-1-dub> <49c3c9ac$1@forums-1-dub> <49c3d6e3@forums-1-dub>
NNTP-Posting-Host: 219.90.142.88
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1237620160 14470 127.0.0.1 (21 Mar 2009 07:22:40 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Sat, 21 Mar 2009 07:22:40 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: j9g2000prh.googlegroups.com; posting-host=219.90.142.88; posting-account=euaBtgoAAAC_vDxfsxmpMKlBxHaHpmRS
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.2; en-US; rv:1.9.1b3) Gecko/20090305 Firefox/3.1b3,gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!border2.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!j9g2000prh.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89035
Article PK: 418290

Also add describe('evaluate(expression,row[,buffer])') to that list.
Then you can sum values etc.

Heck, why isn't evaluate a method on the control?

On Mar 21, 3:48 am, "Jerry Siegel [TeamSybase]"

<jNOsSPAMsiegel@yahoo!.com> wrote:
> I have suggested that in a TW session with engineering - add an optional
> buffer argument to Find and Sort, defaults to Primary! so it doesn't break
> existing code. Should also be able to work on Delete! buffer.
>
> Post the enhancement # and I'll vote for it.
>
> And I've used that same workaround :-(
>
> --
> Report Bugs:http://case-express.sybase.com/cx/welcome.do
> Product Enhancement Requests:http://my.isug.com/cgi-bin/1/c/submit_enhancement
>
> "Jason Lipman" <NOSPAM-jlipman@oppenheimer> wrote in message
>
> news:49c3c9ac$1@forums-1-dub...
>
> > Chris,
>
> > Yup,
>
> > Thank is sort'a what I thought would be the case. Adding a filter argument
> > to thd Find function would be a great enhancement idea for Sybase. I'll
> > get into ISUG and submit it!
>
> > "Chris Pollach" <cpoll...@travel-net.com> wrote in message
> >news:49c3c55a$1@forums-1-dub...
> >> Hi Jason;
>
> >>    I think that you have basically two choices:
>
> >> 1) Drop the Filter - do the Find - then reinstate the Fillter.
> >> - or -
> >> 2) Copy the current filter buffer on the DC to a DataStore and then do a
> >> Find on the DS's primary buffer.
> >> for example ...
>
> >> DataStore        lo_ds
> >> lo_ds    = Create DataStore
> >> lo_ds.DataObject  = DC.DataObject
> >> DC.RowsCopy (1, DC.RowCount ( ), Filter!, lo_ds, 1, Primary!)
>
> >> lo_ds.Find ( ls_your_criteria)
>
> >> HTH
>
> >> --
> >> Regards ... Chris
> >> ISUG - NA RUG Director
> >>http://chrispollach.pbdjmagazine.com
>
> >> "Jason Lipman" <NOSPAM-jlipman@oppenheimer> wrote in message
> >>news:49c3b9a4$1@forums-1-dub...
> >>> PB 10.5.2
>
> >>> I thought there was syntax, but cannot find it...
>
> >>> Before saving a datawindow, I am validating a new row to ensure the
> >>> Primary Key is not being used again. However, the possible dup could be
> >>> in the Filtered buffer.
>
> >>> Is there a way to use Find() against anything other than the default
> >>> Primary! buffer? Is there a better option? I am hoping I do not need to
> >>> move all the data into a Datastore, as Primary Buffer, to solve this.
>
> >>> IE: Is something like this possible... Find(" column.filtered = '123' ")
>
> >>> Thank you,
> >>> Jason Lipman


Chris Pollach Posted on 2009-03-20 17:47:27.0Z
From: "Chris Pollach" <cpollach@travel-net.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <49c3b9a4$1@forums-1-dub> <49c3c55a$1@forums-1-dub> <49c3c9ac$1@forums-1-dub>
Subject: Re: Find() in the Filtered Buffer
Lines: 72
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.5579
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49c3d6af$1@forums-1-dub>
Date: 20 Mar 2009 09:47:27 -0800
X-Trace: forums-1-dub 1237571247 10.22.241.152 (20 Mar 2009 09:47:27 -0800)
X-Original-Trace: 20 Mar 2009 09:47:27 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89027
Article PK: 418280

Tha would be an excellent enhancement for sure ( IMHO)! :-)

"Jason Lipman" <NOSPAM-jlipman@oppenheimer> wrote in message
news:49c3c9ac$1@forums-1-dub...
> Chris,
>
> Yup,
>
> Thank is sort'a what I thought would be the case. Adding a filter argument
> to thd Find function would be a great enhancement idea for Sybase. I'll
> get into ISUG and submit it!
>
>
> "Chris Pollach" <cpollach@travel-net.com> wrote in message
> news:49c3c55a$1@forums-1-dub...
>> Hi Jason;
>>
>> I think that you have basically two choices:
>>
>> 1) Drop the Filter - do the Find - then reinstate the Fillter.
>> - or -
>> 2) Copy the current filter buffer on the DC to a DataStore and then do a
>> Find on the DS's primary buffer.
>> for example ...
>>
>> DataStore lo_ds
>> lo_ds = Create DataStore
>> lo_ds.DataObject = DC.DataObject
>> DC.RowsCopy (1, DC.RowCount ( ), Filter!, lo_ds, 1, Primary!)
>>
>> lo_ds.Find ( ls_your_criteria)
>>
>>
>> HTH
>>
>> --
>> Regards ... Chris
>> ISUG - NA RUG Director
>> http://chrispollach.pbdjmagazine.com
>>
>>
>> "Jason Lipman" <NOSPAM-jlipman@oppenheimer> wrote in message
>> news:49c3b9a4$1@forums-1-dub...
>>> PB 10.5.2
>>>
>>> I thought there was syntax, but cannot find it...
>>>
>>> Before saving a datawindow, I am validating a new row to ensure the
>>> Primary Key is not being used again. However, the possible dup could be
>>> in the Filtered buffer.
>>>
>>> Is there a way to use Find() against anything other than the default
>>> Primary! buffer? Is there a better option? I am hoping I do not need to
>>> move all the data into a Datastore, as Primary Buffer, to solve this.
>>>
>>> IE: Is something like this possible... Find(" column.filtered = '123' ")
>>>
>>> Thank you,
>>> Jason Lipman
>>>
>>>
>>>
>>
>>
>
>


Ivaylo Ivanov Posted on 2009-04-29 11:38:37.0Z
From: "Ivaylo Ivanov" <NOSPAM_i.ivanov@isy-dc.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <49c3b9a4$1@forums-1-dub> <49c3c55a$1@forums-1-dub>
Subject: Re: Find() in the Filtered Buffer
Lines: 66
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.5579
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49f83c3d@forums-1-dub>
Date: 29 Apr 2009 04:38:37 -0700
X-Trace: forums-1-dub 1241005117 10.22.241.152 (29 Apr 2009 04:38:37 -0700)
X-Original-Trace: 29 Apr 2009 04:38:37 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89208
Article PK: 418460

We have to mention that also SetItem() DW/DS/DWCH method is missing Buffer
and OriginalValue arguments, equivalent to GetItemxxx() ones. This limits
the data modification of the rows within Filter and Delete buffers to a
robust dot notation. Not to mention that columnnames in such dot notation
have to be strictly put in the code:

dw_1.Object.mycolumn.Filter[ll_row] = 5

I've added an enhancement request for this one today.

Regards,
Ivaylo

"Chris Pollach" <cpollach@travel-net.com> wrote in message
news:49c3c55a$1@forums-1-dub...
> Hi Jason;
>
> I think that you have basically two choices:
>
> 1) Drop the Filter - do the Find - then reinstate the Fillter.
> - or -
> 2) Copy the current filter buffer on the DC to a DataStore and then do a
> Find on the DS's primary buffer.
> for example ...
>
> DataStore lo_ds
> lo_ds = Create DataStore
> lo_ds.DataObject = DC.DataObject
> DC.RowsCopy (1, DC.RowCount ( ), Filter!, lo_ds, 1, Primary!)
>
> lo_ds.Find ( ls_your_criteria)
>
>
> HTH
>
> --
> Regards ... Chris
> ISUG - NA RUG Director
> http://chrispollach.pbdjmagazine.com
>
>
> "Jason Lipman" <NOSPAM-jlipman@oppenheimer> wrote in message
> news:49c3b9a4$1@forums-1-dub...
>> PB 10.5.2
>>
>> I thought there was syntax, but cannot find it...
>>
>> Before saving a datawindow, I am validating a new row to ensure the
>> Primary Key is not being used again. However, the possible dup could be
>> in the Filtered buffer.
>>
>> Is there a way to use Find() against anything other than the default
>> Primary! buffer? Is there a better option? I am hoping I do not need to
>> move all the data into a Datastore, as Primary Buffer, to solve this.
>>
>> IE: Is something like this possible... Find(" column.filtered = '123' ")
>>
>> Thank you,
>> Jason Lipman
>>
>>
>>
>
>


Philip Salgannik Posted on 2009-03-20 21:14:31.0Z
From: "Philip Salgannik" <philip@MeMyselfAndI.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <49c3b9a4$1@forums-1-dub>
Subject: Re: Find() in the Filtered Buffer
Lines: 28
Organization: MeMyselfAndI
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.5579
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49c40737@forums-1-dub>
Date: 20 Mar 2009 13:14:31 -0800
X-Trace: forums-1-dub 1237583671 10.22.241.152 (20 Mar 2009 13:14:31 -0800)
X-Original-Trace: 20 Mar 2009 13:14:31 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89033
Article PK: 418283

For a simple test like this, quickest would be to assign the content of the
column in question from the Filter buffer to an array with one dot notation
statement and then loop on the array...

"Jason Lipman" <NOSPAM-jlipman@oppenheimer> wrote in message
news:49c3b9a4$1@forums-1-dub...
> PB 10.5.2
>
> I thought there was syntax, but cannot find it...
>
> Before saving a datawindow, I am validating a new row to ensure the
> Primary Key is not being used again. However, the possible dup could be in
> the Filtered buffer.
>
> Is there a way to use Find() against anything other than the default
> Primary! buffer? Is there a better option? I am hoping I do not need to
> move all the data into a Datastore, as Primary Buffer, to solve this.
>
> IE: Is something like this possible... Find(" column.filtered = '123' ")
>
> Thank you,
> Jason Lipman
>
>
>
>