DataTable - SQL delete command

[anony]

Hi,

From what I gather, you cannot issue SQL statements against a DataTable.
Just wanted to verify this, and ask, why not? I would like to issue a
delete statement against a memory resident DataTable.

Thanks.

 

[Eliyahu Goldin]

No, you can't. The guy who handles SQL statements is called database server.
DataTable is just a class that has its own methods.

Eliyahu

 

[anony]

Thanks for the reply. I would hope this functionality is implemented in a
future release. There's no reason to involve a database server for my
requirements. Instead, I'll have to write some clunky code in order to
achieve the same results of a simple DELETE FROM statement.