March 15th, 2004, 11:08 AM
About a SQL SELECT
I have a problem with a SQL statement:
SELECT ID FROM DEP WHERE ID='A';
It works fine with a IB/FB manager, but I must do it in a Java app:
Statement stm = Connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
rs = stm.executeQuery("SELECT ID FROM DEP WHERE ID='A';");
With a single "SELECT * FROM DEP", all works fine, but it doesn´t with a "WHERE" clause.
Can anyone help me? please?
Thank you everybody.
March 16th, 2004, 02:40 AM
Leave out the ; at the end. When sending SQL statements via JDBC you are not allowed to include the semicolon (true for all DBMS)