Re: Problem with delimiters using embedded SQL.

[Alan Shore <AlanShore@xxxxxxxx>]

Hi Marco
the one thought that comes to mind is to search the string looking for
QUOTE

D Quote           c                   Const('''')

Then substring the string out and re-format it to something like this

c                   eval      Sqlstatement = Stringpart01  + Quote +
c                                            Stringpart02 + Quote +
Stringpart03



Alan Shore

NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx



                                                                       
             Marco Facchinetti                                         
             <facchinetti@yaho                                         
             o.com>                                                     To
             Sent by:                  RPG programming on the AS400 /  
             rpg400-l-bounces@         iSeries <rpg400-l@xxxxxxxxxxxx> 
             midrange.com                                               cc
                                                                       
                                                                   Subject
             08/23/2006 02:35          Problem with delimiters using   
             PM                        embedded SQL.                   
                                                                       
                                                                       
             Please respond to                                         
              RPG programming                                          
              on the AS400 /                                           
                  iSeries                                              
             <rpg400-l@midrang                                         
                  e.com>                                               
                                                                       
                                                                       




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.