MySQL Bugs: #60805: Practice purpose

Bug #60805	Practice purpose
Submitted:	8 Apr 2011 11:31	Modified:	8 Apr 2011 12:37
Reporter:	NIRVESH` NIRVESH`	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	Tests: Server	Severity:	S3 (Non-critical)
Version:		OS:	Windows
Assigned to:		CPU Architecture:	Any

Description:
This is my code for deleting a record from the database, but this doesn't work. Is this a bug. Hoping for your Favorable repy\ly
connector c = new connector();
            ResultSet rs = null;
            Statement st = null;
         
            st = c.connection.createStatement();
            rs= st.executeQuery("Select Caseno from patientrecord where Caseno = '"+jcase.getText()+"'");
            rs.next();
            st.executeUpdate("delete from patientrecord where Caseno = '"+rs.getInt(11)+"'");
            System.out.println("One raw deleted");
            st.close();
            c.connectionClose();

How to repeat:
 I checked this query with the ms access database and this works really well.
So i requested you to go with this,
Thank you.

Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.