Can't use "delete from" in odbc?

  • Thread starter Thread starter babylon
  • Start date Start date
B

babylon

OdbcConnection con = new OdbcConnection("DSN=myTestDB");
OdbcCommand c = new OdbcCommand();
c.Connection = con;
con.Open();
c.CommandText = "delete from employee.txt where ID=5";
ret = c.ExecuteNonQuery();

gives error
ystem.Data.Odbc.OdbcException: ERROR [HY000] [Microsoft][ODBC Text Driver]
Dele
ing data in a linked table is not supported by this ISAM.

but no error if
c.CommandText = "delete from employee.txt where 'ID'='5'";
however, this does not delete anything....

pls help..
 
Back
Top