hi friends:
i'm working with sapdb and java. My problem is that,
i can't insert or update to a field of type
LONGVARCHAR.
i'm staying
this is my code:
String queryStr = "UPDATE " +
DatabaseNames.AREA_TABLE
+ " SET id_especialidad = ? , "
+ "nombre = ? , "
+ "descripcion = ? , "
+ "fecha_creacion = ? , "
+ "estado = ? "
+ " WHERE id_area = ? ";
Debug.println("updateString is: "+ queryStr);
PreparedStatement stmt = null;
try {
getDBConnection();
stmt =
dbConnection.prepareStatement(queryStr);
//
stmt.setString(1,details.getSpecialty().id.trim());
stmt.setString(2,details.getName().trim());
stmt.setString(3,details.getDescription());
stmt.setDate(4,details.getDateCreate());
stmt.setString(5,details.getStatus().trim());
stmt.setString(6,details.getAreaPK().id.trim());
//
stmt.executeUpdate();
I'm thankful.
_________________________________________________________
Do You Yahoo!?
Informaci�n de Estados Unidos y Am�rica Latina, en Yahoo! Noticias.
Vis�tanos en http://noticias.espanol.yahoo.com
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
