I am new to Filemaker .Below is the code,I am trying to perform find with year value as '2017'.In the database I can see that there is a record with that value but still I am getting as No Records match the request.
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
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.
Retrieving data ...