Kiran Angara
2017-09-19T08:52:03Z
Hello,

"FindSearchMatchRow" method is really a awesome feature to avoid loops in the program logic. First of all thanks for that.

In my case would like to request for suggestion or solution.
When the user start select/enter data in the iGrid a new blank row will be added automatically after the current row.
So when use this method it taking last empty row cell (quantity) in to consideration as empty cell (correct as per method) and display message.

lRow = FindSearchMatchRow(vSearchCol:="quantity",sSearchString:="") OR _
FindSearchMatchRow(vSearchCol:="quantity",sSearchString:="0")
If lRow > 0 Then
....

InternalNote.jpg

Click to View Image48 View(s)



Please Advice.

Thank You.
Igor/10Tec
2017-09-19T12:31:16Z
Frankly speaking, I did not understand what task you want to implement with the help of the FindSearchMatchRow method. Can you give us more details about that?
Kiran Angara
2017-09-20T00:23:48Z
I would like to find empty/zero value cells in quantity and checking lot no column which are mandatory.
Igor/10Tec
2017-09-20T13:44:42Z
Then you should simply check the value returned by FindSearchMatchRow. If it equals the last row used to enter new data, then nothing was found.

This is not a problem of the method. In fact, your question concerns the logic of using the iGrid member.