[SQL] Firebird lock and select unlocked fields

I have a query

SELECT FIRST 10 * FROM FP_TASKS WITH LOCK


but I have multiple clients using a table, and I need for each selected client 10 rows that are not locked.. Is there any way to do something like below?

SELECT FIRST 10 * FROM FP_TASKS
WHERE ROW NOT LOCKED
WITH LOCK

Continue reading...