We need to delete N first records from a DBF file with the following columns CODE, NAME and some other attributes.
I use Receiver JDBC Adapter with additional DBF driver.
I tried to use action SQL_DML with the following access value:
DELETE FROM Table_name WHERE CODE IN (SELECT TOP 10 CODE FROM Table_name).
But it deletes only one record instead of deleting ten.
Could you help me to find out why is that so and how to delete first N records?