Hello,
the following code snippet demonstrate how you can update a LONG VARCHAR
column with a java.lang.String value:

       String strInput = // read from html form
       PreparedStatement ps = this.connection.prepareStatement("UPDATE " +
DatabaseNames.AREA_TABLE
                                                                + " SET
field_long_var_char= ? ");
       ps.setString(1,strInput);
       int erg = ps.executeUpdate();
       this.connection.commit();

Regards,
Marco
----------------------------------------------
Marco PASKAMP
SAP DB, SAP Labs Berlin

> -----Original Message-----
> From: jaime1 [mailto:[EMAIL PROTECTED]]
> Sent: Montag, 6. Mai 2002 18:37
> To: [EMAIL PROTECTED]
> Subject: problem with the filed LONG VARCHAR
> 
> 
> People i need to update an field LONG VARCHAR in SAPDB,
> I am programing in Java and read my text field  from html 
> form , the problem
> it's i don't know how make the sintaxis in java for update 
> this field an
> Table
> 
> String strInput = // read from html form
> 
> String queryStr = "UPDATE " + DatabaseNames.AREA_TABLE
>             + " SET field_long_var_char= ? " ;
> 
> PreparedStatement stmt = con.preparedStatement(queryStr);
> stmt.setAsciiStream(1, FUNCTION_X(strInput));
> 
> how implement the FUNCTION_X
> 
> regards
> Jaime
> _______________________________________________
> sapdb.general mailing list
> [EMAIL PROTECTED]
> http://listserv.sap.com/mailman/listinfo/sapdb.general
> 
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to