Loop though specific table column and select row when found

[former_member549453]

If I want to update specific quota I need to script to check for the Quota Arr. Number column in below displayed table. If the number is same as in excel input file (COL3) than it should select the same row as the number is found. In below example it should select row 2.

I tried below code but the script stops at: session.findById("wnd[0]/usr/tblSAPDM06QTC_0205/txtEQUK-QUNUM[3,i]").text

Runtime error ‘619’:

The control could not be found by id.

i = 0

Do

session.findById("wnd[0]/usr/tblSAPDM06QTC_0205/txtEQUK-QUNUM[3,i]").text
session.findById("wnd[0]/usr/tblSAPDM06QTC_0205/txtEQUK-QUNUM[3," & CStr(i) & "]").caretPosition = 5

If session.findById("wnd[0]/usr/tblSAPDM06QTC_0205/txtEQUK-QUNUM[3,i]").text = COL3 then

session.findById("wnd[0]/usr/tblSAPDM06QTC_0205").getAbsoluteRow(i).selected = true

Exit Do
End if

i = i + 1

Loop

[Sandra_Rossi]

Error easy to find, check twice your code before asking 😉

"wnd[0]/usr/tblSAPDM06QTC_0205/txtEQUK-QUNUM[3,i]"

[MateuszAdamus]

Hello

What is this line for?

session.findById("wnd[0]/usr/tblSAPDM06QTC_0205/txtEQUK-QUNUM[3,i]").text

You're not assigning read value nor setting any new value. What is it for?

Why aren't you concatenating the i value to ID string all the time as you do in the IF statement?

Might be good to have a local variable with the ID concatenated string and use that variable everywhere.

Kind regards,

Mateusz

[former_member549453]

Thank you Mateusz!

Updated code like this instead. Still don't know what

CStr(i) exactly does but it certanly seems to do the trick 🙂

i = 0

Do

session.findById("wnd[0]/usr/tblSAPDM06QTC_0205/txtEQUK-QUNUM[3," & CStr(i) & "]").caretPosition = 5
If session.findById("wnd[0]/usr/tblSAPDM06QTC_0205/txtEQUK-QUNUM[3," & CStr(i) & "]").text = COL3 then
session.findById("wnd[0]/usr/tblSAPDM06QTC_0205").getAbsoluteRow(i).selected = true

Exit Do
End if

i = i + 1

Loop

[MateuszAdamus]

It's always good to check the documentation: https://docs.microsoft.com/en-us/dotnet/visual-basic/language-reference/functions/type-conversion-fu...

Kind regards,
Mateusz

[former_member549453]

Hello

If want the script to loop through Valid from, Valid to and Quota Arr. Columns (3 columns) to find exact match before selecting the row can same approach be used?

The solution is more for a Source List ME01. For this t code the script would need to check for exact match in 6 diffrent columns. Valid from, Valid to, Vendor ID, Agreement, Line item and MRP. Basically same as above but with more columns to check for exact match.

I did several tries today with no success.

[former_member549453]

Here is my best try.

It gives error: The conrol could not be found by id. Code:800A026B on session.findById("wnd[0]/usr/tblSAPLMEORTC_0205/ctxtEORD-VDATU[0," & CStr(i) & "]").caretPosition = 0

i = 0
Do
session.findById("wnd[0]/usr/tblSAPLMEORTC_0205/ctxtEORD-VDATU[0," & CStr(i) & "]").caretPosition = 0'Valid From date

session.findById("wnd[0]/usr/tblSAPLMEORTC_0205/ctxtEORD-BDATU[1," & CStr(i) & "]").caretPosition = 0'Valid To date
session.findById("wnd[0]/usr/tblSAPLMEORTC_0205/ctxtEORD-LIFNR[2," & CStr(i) & "]").caretPosition = 0'Vendor ID
session.findById("wnd[0]/usr/tblSAPLMEORTC_0205/ctxtEORD-EBELN[6," & CStr(i) & "]").caretPosition = 0'Agreement number
session.findById("wnd[0]/usr/tblSAPLMEORTC_0205/ctxtEORD-EBELP[7," & CStr(i) & "]").caretPosition = 0'Item line
session.findById("wnd[0]/usr/tblSAPLMEORTC_0205/ctxtEORD-AUTET[10," & CStr(i) & "]").caretPosition = 0 'MRP flag


If session.findById("wnd[0]/usr/tblSAPLMEORTC_0205/ctxtEORD-VDATU[0," & CStr(i) & "]").Text = COL3 AND session.findById("wnd[0]/usr/tblSAPLMEORTC_0205/ctxtEORD-BDATU[1," & CStr(i) & "]").Text = COL4 AND session.findById("wnd[0]/usr/tblSAPLMEORTC_0205/ctxtEORD-LIFNR[2," & CStr(i) & "]").Text = COL5AND session.findById("wnd[0]/usr/tblSAPLMEORTC_0205/ctxtEORD-EBELN[6," & CStr(i) & "]").Text = COL7 AND session.findById("wnd[0]/usr/tblSAPLMEORTC_0205/ctxtEORD-EBELP[7," & CStr(i) & "]").Text = COL8 AND session.findById("wnd[0]/usr/tblSAPLMEORTC_0205/ctxtEORD-AUTET[10," & CStr(i) & "]").Text = COL12  Then


session.findById("wnd[0]/usr/tblSAPLMEORTC_0205").getAbsoluteRow(i).selected = true 


Exit Do
End if
i = i + 1
Loop

[former_member549453]

Am I on the right track or is diffrent approach needed? 🙂

[former_member549453]

I found the error line as well. It's stated in my post. Read my post twice before commenting 😉

[Sandra_Rossi]

What I meant is that in the line below that line, you have solved the error ([3," & CStr(i) & "]"), so it's just that you didn't check twice 😉

session.findById("wnd[0]/usr/tblSAPDM06QTC_0205/txtEQUK-QUNUM[3," & CStr(i) & "]").caretPosition = 5

[former_member549453]

Thanks! I whish it was that easy though. I just copied from something that looked similar when googled. It didn't work for my code. Much easer to find the error if you know what to look for 🙂