In your script, you are not using ExecuteSQL to perform the find. The results of your SQL queries are not used in the scripted find in any way.
From what I see, if you are getting a "no records found" error, then you do not have a record where the value 2017 is in Year for any record of this table.
The Find & ExecuteSQL have nothing to do with each other.
SELECT is a "find", but the results you get is a text field. It can be parsed, but it does NOT narrow down your found set of records in any way.
Sent from miPhone
1 of 1 people found this helpful
There is the additional problem that this is based on a virtual list technique; and then trying to narrow the results with a FIND operation. Since the virtual list method used here the unstored calc get( recordNumber) for rowNum, you cannot perform a FIND on the results.