[MonetDB-users] delete query with where clause

pawan123 pawan.gupta at nucleussoftware.com
Wed Oct 10 07:13:15 CEST 2007

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.

View this message in context: http://www.nabble.com/delete-query-with-where-clause-tf4598673.html#a13129555
Sent from the monetdb-users mailing list archive at Nabble.com.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.monetdb.org/pipermail/users-list/attachments/20071009/c15ba410/attachment.html>

More information about the users-list mailing list