The same statement works perfectly well
On the other hand if i run the same query directly in the SQL editor it works fine.
and the same things I run while in the Java query.
Ulf Dittmer wrote:That's not the right syntax for an INSERT statement. If you run that in your SQL tool you should get the same error.
By the way, have you noticed that the you're not using the CODE tags correctly? The way you're applying them they don't accomplish anything - the opening/closing tags go before/after the code. I had corrected those before, but since this is now the third time you're using them like this, please take a moment to check out how your last post looks like. You can edit it to correct the code tags.
Which means in the code i need to write
String s34 = jTextField5.getText();
or it automatically stores null?
And it shows this error now
java.sql.SQLException: Before start of result set