delete all records from a module using SOAP?

[mike.smedley]

I have a custom module (Accounts Receivable). Each night, through a batch process, I am refreshing these records from an external source. In this refresh, I delete all A/R records, and then load new ones from my external source. The only way I know to delete records is by calling set_entries with an array of name-value lists like so:
array(
array( 'name' => 'id' , 'value' => '%s' ),
array( 'name' => 'deleted' , 'value' => "1" )
);

Is there any way I can do something more efficient, like UPDATE table_name SET deleted = 1 ?

[Angel]

You can't execute ad-hoc queries though the SOAP interface, unfortunately, so there is no efficient way to do it. You could try using set_entries() instead though, that might help you a bit.