FM equivalant of SELECT TOP 10...???

[angelleye]

In Access I can use the following SQL statement to return only the last 10 records in the table.

SELECT TOP 10 zID FROM Customers

FileMaker gives me a parsing error on this. In my research I see that MySQL and Oracle have different syntax for this. Does FileMaker have something I can use for this feature?

Any information would be greatly appreciated. Thanks!

[mr_vodka]

How about something like:

Show All Records

Go to Record [(Get Found Count) -9 ]

Omit multiple Records [10]

Show omitted only

[angelleye]

I'm not making a filemaker script. this is a SQL select from a web application connecting to FM via ODBC.

[mr_vodka]

Does FileMaker have something I can use for this feature?

Any information would be greatly appreciated. Thanks!

Well I know that your issue was with the SQL, but the last part of your post seemed as though you were looking for an alternative.

[angelleye]

Sorry for the confusion. I meant an alternative to the SELECT TOP method of limiting the records returned. What I'm really trying to do is limit the number of records that the script goes through to determine if they should be included in the recordset.