what is the meaning of Degree of derived table does not match column list

From: Praveen homkar via JavaKB.com (forum_at_JavaKB.com)
Date: 03/11/05


Date: Fri, 11 Mar 2005 04:23:06 GMT

Hi all

Please tell the meaning of " Degree of derived table does not match column
list" this error.

i am getting this error when i am trying to edit the data in mysql database
,i am using type-1 driver.

con= DriverManager.getConnection("jdbc:odbc:mysql-ansi");
st=con.createStatement
(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs=st.executeQuery("select * from ansidata where SNo="+SNo);
rs.next();
rs.updateString(1,"India");
rs.updateRow();

Please tell me the solution.

-- 
Message posted via http://www.javakb.com