Skip to Content
0
Former Member
Jan 24, 2011 at 12:42 PM

JDBC Receiver SQL_DML Delete first N records

81 Views

Hello, experts!

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?

BR,

Vika