Re: Simple Question for Embedded RPG Gurus...

[Bill Brosch <bbrosch@xxxxxxxxxxxxxx>]

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