Re: Problem with delimiters using embedded SQL.

Just to know, but how to handle many parameters (i.e > 100) ?

Marco

--- rob@xxxxxxxxx wrote:

Standard answer.  Been quite repeated on this list lately.  Stop trying to

embed the actual value into :w_string.  Imbed "parameter markers" instead.
w_string = 'select colA from fileA where PriKey=?';
/end-free
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 :MyVal
C/end-exec

Will place MyVal into the question mark of PriKey.  Yet another reason why

SQL kicks butt on OPNQRYF.

Rob Berendt

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com