DELETING ROW

From: Gabriel López Millán <gabilm(at)dif(dot)um(dot)es>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: DELETING ROW
Date: 2000-07-12 11:13:35
Message-ID: 396C52DF.BBE06E9C@dif.um.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces


Hi all.

I'm traying to delete a row of a table. Te code is:

String query = "DELETE FROM " + ID_REQUEST_TABLE + " WHERE id = '" +
numReq+ "';";
int result = s.executeUpdate(query);
System.out.println("result: " + result);
if(result != 0) {
.....
connection.commit();
}

If file do not exists "result" should be "0" (JDBC API), if exists,
it should be the number of the row that delete. But I always get the
value "1", always, even if the row to delete is 5,6, ... 10.

I'm using postgresql 7.02 with linux RedHat 6.0 and jdk1.2

Cheers, Gabi.

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Bob Kline 2000-07-12 13:40:52 Re: DELETING ROW
Previous Message XWorkers 2000-07-12 01:18:39 ODBC -- how much stable through internet