Filter Browse Records (Urgent)

Sharon Gan

unread,

Mar 8, 2001, 1:23:01 AM3/8/01

to

Hi, Let's say I have a window that has a textbox used LOCAL variable. When I
press OK Button, then it will prompt out a browse to display the matched
data instead of all the records in the database.

For example, I type 'sharon' in the textbox, so the local variable say
'LOC:NAME' will store the 'sharon' value, then I press OK, a browser browse
all the data which the Name contain 'sharon'. How can I able to do this ?

Thank you

Regards,
sharon

Oddmar Dam

unread,

Mar 8, 2001, 1:27:46 AM3/8/01

to

You could set INSTRING(LOC:NAME,1,1) in the filter of the browse, but if
there r many records in the file, it could take a while.

"Sharon Gan" <sharo...@wills.com.sg> skrev i en meddelelse
news:3aa7260a$1...@news.softvelocity.com...

xristos

unread,

Mar 8, 2001, 1:29:48 AM3/8/01

to

Use a range or a filter in your browse procedure.

Sharon Gan <sharo...@wills.com.sg> wrote in message
news:3aa7260a$1...@news.softvelocity.com...

Sharon Gan

unread,

Mar 8, 2001, 1:31:34 AM3/8/01

to

Actually, in the window I have not just one textbox/local variable to store
the data which I want to use to filter. I have at least 3 value need to use
to filter the browse record.

sharon

"Oddmar Dam" <odd...@com-data.fo> wrote in message
news:3aa7...@news.softvelocity.com...

Sharon Gan

unread,

Mar 8, 2001, 1:37:43 AM3/8/01

to

HOW ?

"xristos" <n...@no.com> wrote in message
news:3aa7...@news.softvelocity.com...

Sharon Gan

unread,

Mar 8, 2001, 1:33:55 AM3/8/01

to

sorry sorry, should be global variables to store the values to filter the
browse record.

sharon

"Oddmar Dam" <odd...@com-data.fo> wrote in message
news:3aa7...@news.softvelocity.com...

xristos

unread,

Mar 8, 2001, 4:40:57 AM3/8/01

to

Usually its better to use Ranges because its much faster than filtering. In
your case you want to view all names witch contain a substring. That would
require to use a filter and its gonna be slow.
Try using both, that will make it a bit faster..
In your Record Filter you should write something like this:
(GLO:Var1='' OR GLO:Var1=BRW:Var1) AND
(GLO:Var2='' OR GLO:Var2=BRW:Var2)

etc etc

Sharon Gan <sharo...@wills.com.sg> wrote in message

news:3aa7297c$1...@news.softvelocity.com...

Ron Jolda

unread,

Mar 8, 2001, 6:05:54 AM3/8/01

to

Sharon:
Here is an example of a filter string (WFS) built from several components -
the components in this case are 4 check boxes but they could be anything -
local or global variables:
After the conditions are checked, then the user presses a button to Reset
the display with new filter values and the code is in that button:

IF newp = 1
tfs = 'VTY:New_pt = 1'
.

IF estp = 1
if tfs <> ''
tfs = clip(tfs) & ' and ' & 'VTY:est_pt = 1'
else
tfs = 'VTY:est_pt = 1'
.
.

IF initv = 1
if tfs <> ''
tfs = clip(tfs) & ' and ' & 'VTY:Init = 1'
else
tfs = 'VTY:Init = 1'
.
.

IF fuv = 1
if tfs <> ''
tfs = clip(tfs) & ' and ' & '(VTY:re_check = 1 or VTY:F_U = 1)'
else
tfs = '(VTY:re_check = 1 or VTY:F_U = 1)'
.
.

if tfs = '' and catfs = ''
wfs = ''
elsif catfs <> '' and tfs <> ''
wfs = clip(catfs) & ' and ' & Clip(tfs)
elsif tfs = ''
wfs = catfs
elsif catfs =''
wfs = Clip(tfs)
.
! message(wfs)
BRW1.setfilter(wfs)
thisWindow.Reset(TRUE)

HTH,
Ron Jolda

"Sharon Gan" <sharo...@wills.com.sg> wrote in message
news:3aa7260a$1...@news.softvelocity.com...

Earl R. Coker

unread,

Mar 8, 2001, 10:28:22 AM3/8/01

to

Hi Sharon,

You could use the Xplore Templates from
http://ourworld.compuserve.com/homepages/BrianStaff/ or go to
http://www.tomruby.com/clarion/ and look for another solution.

--
Regards,
Earl
k...@muscanet.com
www.kwiksystems.com

"Sharon Gan" <sharo...@wills.com.sg> wrote in message
news:3aa7260a$1...@news.softvelocity.com...

David Troxell - Encourager Software

unread,

Mar 8, 2001, 11:48:20 AM3/8/01

to

Sharon, you might consider a commercial Clarion add-on for a solution as
well. SearchFlash would be ideal for this. Includes tagging as well.

You can download a demo at the Sterling Data site or download Product
Scope 32 PRO to see SearchFlash in action with the Clarion Third Party
Profile Exchange (a great resource for most of what is available in the
Clarion community).

Product Description - SearchFlash, MFG - Sterling Data
Internet Link - http://www.sterlingdata.com/search.htm

Combines a text search on ALL fields in ALL File Formats with a QBE
search!

Works with ALL File Formats supported by Clarion

David

In article <3aa7260a$1...@news.softvelocity.com>, sharo...@wills.com.sg
says...

--
From Encourager Software - David Troxell,
Email - mailto:eso...@worldnet.att.net
Author of Product Scope 32 PRO -
Profile Exchanges - Home Theater, Search Engines,
Newsgroup - Email, PRO Music USB, Clarion Third Party,
Clarion Application http://www.encouragersoftware.com/