RE: Problem with delimiters using embedded SQL.

This is one case I would definitely use placeholders.
W_String = 'select * from myfile where company = ?';
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 using :company
C/end-exec 


Thanks,
Tommy Holden


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Shore
Sent: Wednesday, August 23, 2006 1:49 PM
To: RPG programming on the AS400 / iSeries
Subject: Re: Problem with delimiters using embedded SQL.


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.