SQL Exception: Invalid cursor state

[duplessis van aswegen]

Hi guys, I'm coding a simple translation program that uses a SQL database to retrieve the words from both languages and then,
when you choose a word from the list, translate it to the corresponding word in the other language.

Here's the Error:

java.sql.SQLException: [Microsoft][ODBC Driver Manager] Invalid cursor state

And here's the code:

if(ae.getSource() == bTranslate)
    	{    		
    		try
	    	{
		    	if(language.equals("AFR"))
		    	{
		    		int index = cbSelectWord.getSelectedIndex();
		    		System.out.println("INDEX "+index);
		    		stm = con.createStatement();
			    	sql = "SELECT EnglishWords FROM EnglishTable WHERE WordID = " + index;
			    	rs = stm.executeQuery(sql);
			    	String word = rs.getString("EnglishWords");
		    	}
		    	if(language.equals("ENG"))
		    	{
		    		int index = cbSelectWord.getSelectedIndex();
		    		System.out.println("INDEX "+index);
		    		stm = con.createStatement();
			    	sql = "SELECT AfrikaansWords FROM AfrikaansTable WHERE WordID = " + index;
			    	rs = stm.executeQuery(sql);
			    	String word = rs.getString("AfrikaansWords");	    		    		
		    	}
	    	}
	    	catch(SQLException sqle)
	    	{
	    		sqle.printStackTrace();
	    	}
    	}

Any help would be appreciated.
Thanks.

[duplessis van aswegen]

nevermind guys I fixed it...

[Jeanne Boyarsky]

Welcome to CodeRanch!

I assume you fixed it by adding rs.next(). If it was something else, please share so others can learn from your experience.