How to GetRowNum using text From DW

View Replies (1)

Resolved How to GetRowNum using text From DW

How-to

Votes

Undo

jh j
PowerBuilder
Friday, 10 February 2023 02:16 AM UTC

When I have

A Data Window and a button, a sle like this in window. and run this

id data

ap4 pmgw

pm7 pmgwt

…

go3 gmtp

aw5 gjp

[Button(Search)] [sle text]

when i type in sleText with go3

and click button then

i want to move row focus to go3

In this case,

How i can get row as integer where go3 is in position

sorry for my bad english skill..

PowerBuilder

Responses (1)

Sivaprakash BKR Accepted Answer Pending Moderation

Friday, 10 February 2023 12:36 PM UTC
PowerBuilder
# 1

Simple solution would be

// Button clicked event

ls_temp = sle_search.Text
ls_search_colname = 'id'
ll_row = dw_1.Find('upper(' + ls_search_colname + ') like "' + Upper(ls_temp) + '%"', 1, dw_1.RowCount())
If ll_row > 0 and ll_row <= dw_1.RowCount() Then dw_1.ScrollToRow(ll_row)

HTH

Happiness Always
BKR Sivaprakash

Comment

jh j
Saturday, 11 February 2023 02:15 AM UTC

Thanks so much!!

Helpful 0

There are no comments made yet.

Page :
1

There are no replies made for this question yet.
However, you are not allowed to reply to this question.

Please login to post a reply

You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »

Forgot Password?

We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.