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.

Closest match

2 posts in Objects Last posting was on 2006-10-05 11:42:03.0Z
AJ Posted on 2006-10-05 04:09:35.0Z
From: "AJ" <ajithk@fernstar.net.au>
Newsgroups: sybase.public.powerbuilder.objects
Subject: Closest match
Date: 4 Oct 2006 21:09:35 -0700
Organization: http://groups.google.com
Lines: 8
Message-ID: <1160021375.498379.307700@m73g2000cwd.googlegroups.com>
NNTP-Posting-Host: 210.23.136.94
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1160021381 1361 127.0.0.1 (5 Oct 2006 04:09:41 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 5 Oct 2006 04:09:41 +0000 (UTC)
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: m73g2000cwd.googlegroups.com; posting-host=210.23.136.94; posting-account=-IWSeg0AAAA3kSJSOIl906Jh2WXgKVhZ
Path: forums-1-dub!forums-master!newswest.sybase.com!newsfeed2.dallas1.level3.net!news.level3.com!postnews.google.com!m73g2000cwd.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:9086
Article PK: 736275

Can someone help me on this issue? Are there any functions to do this?

I am performing a find in a data window, the find should return the
closest row matched. For example finding (B50) in a set of rows (A100,
B100, C100.. ) should return 2 (2nd row).

Thanks in advance.


Carlos Guilherme Blos Posted on 2006-10-05 11:42:03.0Z
From: Carlos Guilherme Blos <guilherme.blos@quantiza.com>
User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.objects
Subject: Re: Closest match
References: <1160021375.498379.307700@m73g2000cwd.googlegroups.com>
In-Reply-To: <1160021375.498379.307700@m73g2000cwd.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: static193-48.static.quantiza.com
X-Original-NNTP-Posting-Host: static193-48.static.quantiza.com
Message-ID: <4524ef8b$1@forums-1-dub>
Date: 5 Oct 2006 04:42:03 -0700
X-Trace: forums-1-dub 1160048523 201.7.193.48 (5 Oct 2006 04:42:03 -0700)
X-Original-Trace: 5 Oct 2006 04:42:03 -0700, static193-48.static.quantiza.com
Lines: 17
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:9087
Article PK: 736272

Hi,
You can set your expression to find the equal or greater matching value.
For Example:
ls_find = "Field >= 'B50'"

I hope it be useful for you.
Guilherme

AJ wrote:
> Can someone help me on this issue? Are there any functions to do this?
>
> I am performing a find in a data window, the find should return the
> closest row matched. For example finding (B50) in a set of rows (A100,
> B100, C100.. ) should return 2 (2nd row).
>
> Thanks in advance.
>