Re: Simple Question for Embedded RPG Gurus...

Yes (to the universal way that is!).

You are taking your string, and executing it as is using an execute immeadiate.  Instead, use a prepared statement.
Then your string below looks like:
  EVAL      SqlStmt = ''
            + 'UPDATE HWSRSRL                          '
            + ' SET                                    '
            + '   BLCONO = ?
            + '  ,BLCUST = ?
            + '  ,BLCSTN = ?
            + '  ,BLCODE = ?'

and the update uses the parameter markers.  Because the field never goes thru the conversion from value to string to
value (only value to value!), the single quote is not a problem.

Bill


Konrad Underkofler wrote:

We are doing a dynamic prepare of a statement to update a record
and have found one field can contain the dreaded single quote.
The joblog indicates that token "s" is not valid because of the
CusNam of Denny's.

 EVAL      SqlStmt = ''
           + 'UPDATE HWSRSRL                          '
           + ' SET                                    '
           + '   BLCONO = ' + %EDITC(Co#:'3')
           + '  ,BLCUST = ' + %EDITC(Cus#:'3')
           + '  ,BLCSTN = ''' + CusNam + ''''
           + '  ,BLCODE = ''' + NewStat + ''''

Simple fix? Any universal way to fix this?

Thanks ahead of time.

Konrad Underkofler

_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

--

Bill Brosch

Swift Technologies
920 Davis Rd - Suite 202
Elgin, Il 60123

email:  bbrosch@swiftorder.com
http:   www.swiftorder.com
phone:  847-289-8339
fax:    847-289-8939