Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search a word in a line result of a filtered field from a DataWindow

Status
Not open for further replies.
RubensLott

RubensLott

Programmer
Oct 2, 2017
10
BR
Good morning all!

I have a complicated question here.... complicated to explain what I do need too....
I have a window to search for cities and the cities shown are result of a DataWindowChild filtered by region/state..... OK so far?
Then I need a search script to find a city by writing a part ofthe name instead of writing the name since the begining....
f.ex. I can find "New York" just writing "York" instead of "New Y".... Is that clear???
I tried to use FIND but it doesn't work the way I need....
Can anyone help me? I need a very big tip......

Thanks in advance....
 
Sort by date Sort by votes
Good morning.....

I already found a way....
I used the following syntax:

ll_found_row = dw_1.Find("Lower(#2) like '%" + Lower(is_filt) + "%'", 1, 99999)

But thank you all anyway.....

This issue can be closed!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

C
  • Locked
  • Question
Copy file from Sybase db to a network share that powerbuilder user does not have access to
Replies
0
Views
594
CharlesSwaim
C
CFauvel2
  • Locked
  • Question
I am trying to hide an Adobe Ole Control error from the user using a nested Try/Catch.
Replies
1
Views
465
CFauvel2
CFauvel2
RubensLott
  • Locked
  • Question
Open a PDF file stored on a table
Replies
1
Views
539
RubensLott
RubensLott
RubensLott
  • Locked
  • Question
HOW TO SET A PRINTER ON POWERBUILDER 5
Replies
0
Views
450
RubensLott
RubensLott
JOELDD
  • Locked
  • Question
HOW TO SHOW FIRST COLUMN ON EACH PAGE OF AN INFOMAKER REPORT
Replies
0
Views
396
JOELDD
JOELDD

Part and Inventory Search

Sponsor

Back
Top