Re: Problem with delimiters using embedded SQL.

You have to insert another apostrophe for every one that they enter. So that 
'Bob's stuff' comes out as 'Bob''s stuff' in the SQL statement.
  ----- Original Message ----- 
  From: Marco Facchinetti 
  To: RPG programming on the AS400 / iSeries 
  Sent: Wednesday, August 23, 2006 2:35 PM
  Subject: Problem with delimiters using embedded SQL. 


  I'm having a problem with SQLRPGLE that I don't how to fix.

  We currently use embedded SQL:

  C/exec sql
  C+  PREPARE S1 FROM :W_STRING
  C/end-exec
  C/exec sql
  C+  DECLARE CURS1 CURSOR FOR S1
  C/end-exec
  C/exec sql
  C+  OPEN CURS1
  C/end-exec

  and then FETCH ...

  The problem is that sometimes users put apostrophe "'" inside the search
  arguments and the prepare statement fails (i.e Regent's).

  Must be easy but I don't how to handle it.

  Thanks in advance

  Marco

  __________________________________________________
  Do You Yahoo!?
  Tired of spam?  Yahoo! Mail has the best spam protection around 
  http://mail.yahoo.com 
  -- 
  This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
  To post a message email: RPG400-L@xxxxxxxxxxxx
  To subscribe, unsubscribe, or change list options,
  visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
  or email: RPG400-L-request@xxxxxxxxxxxx
  Before posting, please take a moment to review the archives
  at http://archive.midrange.com/rpg400-l.