When I use without where clause
 
if ((hdl = mapi_query(dbh,"select * from logException )) == NULL || mapi_error(dbh) != MOK) die(dbh, hdl); It is working fine.

But when I use with where condition

if ((hdl = mapi_query(dbh,"delete * from logException where logid=1 )) == NULL || mapi_error(dbh) != MOK) die(dbh, hdl); It is deleting the record only from memory not from database.

<br><hr align="left" width="300">
View this message in context: <a href="http://www.nabble.com/delete-query-with-where-clause-tf4598673.html#a13129555">delete query with where clause</a><br>
Sent from the <a href="http://www.nabble.com/monetdb-users-f4367.html">monetdb-users mailing list archive</a> at Nabble.com.<br>