|
I respectfully suggest you consider replacing SQL with calls to an RPG or COBOL program. While it's a little bit of upfront work, it's far easier to maintain in the long run, and performs much better. Joe > -----Original Message----- > From: Xu, Weining > > I am using JDBC to perform update/insert for DB2 on AS400. The user types > inputs from a Java GUI. For example, when user types in "Tom's desk" in a > text field. I will update the field with the typed string. The partial > code is like this: > > String desc = getJTextFieldDesc().getText(); > > String update = "update myTable set DESCRIPTION = '"+desc+"' > where ID = 1"; > > stmt.createStatement(); > stmt.executeUpdate(update); > > The update will return error, since the string passed into SQL update > statement would be 'Tom's Desk'. The SQL hit the first closing " ' " > after letter m rather after letter k. > > Any solutions? Thanks for your help.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.