problem with inserting new record

[gerard kowara]

Hi All,

I have this following code:

Statement stmtInsert = connection.createStatement();
String test = "insert into calltract (transaction_id,location_code) values (1,\"01\")";
stmtInsert.executeUpdate(test);


and the result is:
No data - zero rows fetched, selected, or processed

The purpose of this code is to insert data into table "calltract"

Any Idea what wrong with this code?

[masijade]

Lets see some more of the code around this. Namely the try/catch/finally block in which it occurs.

One thing though, that "\"01\" should probably be '01'