How to use INSTRING in a filter?

[DonRidley]

Hello,

I want to use INSTRING in a filter.  I have a local variable being used for entering search data.  I want the text entered in that field to be searched for in a field in my browse.

Here's part of what I;ve been trying:

(Instring(upper(p_web.GSV(<39>LOC:Owner<39>)),upper(p_web.GSV(<39>PER:Owner<39>)),1,1) > 0

LOC:Owner is the search field.  PER:Owner is the field being searched.  I do not want to use a standard locator.  I want the user to be able to enter data and click a search button.

Perhaps INSTRING is not the best way.

Any suggestions appreciated,

Don

NetTalk 5.37
TPS

[DonRidley]

I basically want to duplicate the effect of entering data in a locator field but with my own entry control and such...if possible.

Don

[DonRidley]

Can INSTRING be used this way?

[kevin plummer]

Try something like...

loc:FilterWas = 'Instring(<39>' & Clip(Loc:UserLogin) & '<39>,POMT:Approved,1,1) > 0'

[DonRidley]

Hey Kevin,

Yours didn't work but it did get me pointed int he right direction.

Here's what did work...

' Instring(<39>' & Clip(p_web.GSV('Loc:Owner')) & '<39>,PER:Owner,1,1) > 0'

THANK YOU!!!!!!

Don

[kevin plummer]

Well it works if the local variable is primed with the GSV but I thought you would work that out for yourself... BTW you don't need to clip GSV's as they are returned clipped.

[DonRidley]

Ah.. a GSV automatically clips.. didn't know that.

Thanks Kevin!!

[Bruce]

all p_web methods that return a string, return a clipped string.

cheers
Bruce

[DonRidley]

Awesome!  Thanks guys!   I have been away from NetTalk for too long!

Don