fail to update.

[joo how]

updateButton.addActionListener(new ActionListener(){
            public void actionPerformed(ActionEvent e){

                String id = idText.getText();
                int newid = Integer.parseInt(id);
                String e_name = e_nameText.getText();
                String job = jobText.getText();
                String e_ic = e_icText.getText();
                String date = dateText.getText();
                String sal = salText.getText();
                String e_contact = e_contactText.getText();
                String e_email = e_emailText.getText();
                String e_addr = e_addrText.getText();
                String e_city = e_cityText.getText();
                String e_zip = e_zipText.getText();
                String e_country = e_countryText.getText();
                String pass = passText.getText();

                try{


                    idText.setText(String.valueOf(resultSet.getInt("EmpID")));
                    e_nameText.setText(resultSet.getString("EmpName"));
                    jobText.setText(resultSet.getString("Job"));
                    e_icText.setText(resultSet.getString("NRIC"));
                    dateText.setText(String.valueOf(resultSet.getDate("HireDate")));
                    salText.setText(resultSet.getString("Salary"));
                    e_contactText.setText(resultSet.getString("Contact"));
                    e_emailText.setText(resultSet.getString("Email"));
                    e_addrText.setText(resultSet.getString("Address"));
                    e_cityText.setText(resultSet.getString("City"));
                    e_zipText.setText(String.valueOf(resultSet.getInt("Zipcode")));
                    e_countryText.setText(resultSet.getString("Country"));
                    passText.setText(resultSet.getString("Password"));

                    resultSet.updateInt("EmpID", newid);
                    resultSet.updateString("EmpName", e_name);
                    resultSet.updateString("Job", job);
                    resultSet.updateString("NRIC", e_ic);
                    resultSet.updateString("HireDate", date);
                    resultSet.updateString("Salary", sal);
                    resultSet.updateString("Contact", e_contact);
                    resultSet.updateString("Email", e_email);
                    resultSet.updateString("Address", e_addr);
                    resultSet.updateString("City", e_city);
                    resultSet.updateString("Zipcode", e_zip);
                    resultSet.updateString("Country", e_country);
                    resultSet.updateString("Password", pass);
                    resultSet.updateRow();
                    JOptionPane.showMessageDialog(null,"Record updated.");


                }catch(Exception ex){
                    System.out.println(ex.toString());
                }
            }
        });

the result was
java.sql.SQLException: No data found
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]Error in row
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]Invalid cursor position; no keyset defined


anyone can help ?

[Added code tags - see UseCodeTags for details]

[William P O'Sullivan]

It looks like you haven't established the cursor position.

You can only update something that you have already retrieved or use a Where clause in standard sql/jdbc.

WP

[joo how]

can you teach me what i need to do ?? i am new in this == was helping my friend to solve this problem.

[Greg Charles]

Welcome to JavaRanch!

You can see an example here. If you're still having trouble post a small example that shows how you create the query and just update one field.

[Wendy L Gibbons]

You haven't shown us what sort of result set you have, as this only works on certain types (after a quick read of the API)

http://docs.oracle.com/javase/6/docs/api/java/sql/ResultSet.html

[joo how]

Greg Charles wrote:Welcome to JavaRanch!

You can see an example here. If you're still having trouble post a small example that shows how you create the query and just update one field.

thanks! Greg.
I type the exactly what the page have, but still give me the same error. the example :


updateButton.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){

int id = 520;
String city = "KL";


try{

statement = connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
resultSet = statement.executeQuery("select * from Employee");
resultSet.first();

resultSet.updateInt("EmpID", id);
resultSet.updateString("City", city);

resultSet.updateRow();
JOptionPane.showMessageDialog(null,"Record updated.");


}catch(Exception ex){
System.out.println(ex.toString());
}
}
});

[joo how]

Wendy Gibbons wrote:You haven't shown us what sort of result set you have, as this only works on certain types (after a quick read of the API)

http://docs.oracle.com/javase/6/docs/api/java/sql/ResultSet.html

do you mean this i missed?

statement = connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
resultSet = statement.executeQuery("select * from Employee");

[Wendy L Gibbons]

joo how wrote:

Wendy Gibbons wrote:You haven't shown us what sort of result set you have, as this only works on certain types (after a quick read of the API)

http://docs.oracle.com/javase/6/docs/api/java/sql/ResultSet.html

do you mean this i missed?

statement = connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
resultSet = statement.executeQuery("select * from Employee");

yes in the first post, but not the later post.

[joo how]

Wendy Gibbons wrote:

joo how wrote:

Wendy Gibbons wrote:You haven't shown us what sort of result set you have, as this only works on certain types (after a quick read of the API)

http://docs.oracle.com/javase/6/docs/api/java/sql/ResultSet.html

do you mean this i missed?

statement = connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
resultSet = statement.executeQuery("select * from Employee");

yes in the first post, but not the later post.

I added resultSet.absolute(1);
but still giving me the error : java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]Error in row.

[joo how]

Guys! thanks! i solved it

[Greg Charles]

Good for you! It would be nice if you could explain how you fixed it. Then everyone learns!

[joo how]

haha. sure!

one of my friend told me the reason why error in row is because
1. One or more required fields were not filled
2. One of entered values do not conform field type (character values in numeric or date fields)
3. You trying to enter a value into field which is of Autonumber type.
4. You have a relationship between tables that requires you to put into foreign key field one of existing values from another table. If you put value that don't exist in another table you see the same error.

then i found there is one data type in access was wrong. so, after i changed it. it works!

[Greg Charles]

Great, thanks! I hope you'll stick around and ask and/or answer some more questions here!