[pgsql-jp: 41439] Re: 動的SQLのコロンの検索について

[Iwaoka, Yoshinao]

$B4d2,$G$9!#(B

$BJV?.$,CY$/$J$j?=$7Lu$"$j$^$;$s!#(B

$B$4;XE&$NDL$j!V(BToo few arguments in line xxx.$B!W$N%(%i!<$,JV$C$F$-$^$9!#(B

>$BCM$r!V(B'$B!W$G3g$C$F$$$k>l9g$K$O!"!V(B:$B!W$,4^$^$l$F$$$k!"4^$^$l$F$$$J$$$K78(B
>$B$o$i$:!"$=$NCM$K0lCW$9$k9T$,$"$l$PJV$C$F$/$k$O$:$G$9!#(B
>
$BCM$r!V(B'$B!W$G3g$C$F$F!"@5>o$K8!:w7k2L$,JV$k$3$H$r3NG'$7$^$7$?!#(B

$B$?$@!"3:Ev2U=j$OFC<l$J$3$H$r$7$F$^$7$F!"%G!<%?$K!V!o!W%^!<%/$,$"$j!"(B
$B0J2<$N(BSQL$B$r<B9T$7$F$*$j$^$9!#(B

>-------------------------------------------------------------------------
Int Select_Table_Z ( $B8!:wJ8;zNs(B, $B8!:w%G!<%?(B, errcode ) {

#define L_SQL_FORMAT "SELECT a, b, c FROM table_z WHERE d = $quo$%s$quo$ "

        EXEC SQL BEGIN DECLARE SECTION;
                char hostStatement[1024];
                char searchdata1 [1024];
        EXEC SQL END DECLARE SECTION;

        Sprint( hostStatement , L_SQL_FORMAT , $B8!:wJ8;zNs!!(B);

        EXEC SQL PREPARE getStatCtlSql FROM :hostStatement;                                                                                  
        EXEC SQL DECLARE CUR_STATCTL_SELECT CURSOR FOR getStatCtlSql;                                                                        
        EXEC SQL OPEN CUR_STATCTL_SELECT;
        while ($B%F!+!<%?=*N;$^$G(B) {
                EXEC SQL FETCH CUR_STATCTL_SELECT                 
                INTO :searchdata1 ;
                Memcpy( $B8!:w%G!<%?(B, searchdata1, strlen(searchdata1) );
        }
$B!!!!!!!!(BEXEC SQL CLOSE CUR_STATCTL_SELECT;

        return(OK)
}
>-------------------------------------------------------------------------

$B!Z=$@5A0![(B
#define L_SQL_FORMAT "SELECT a, b, c FROM table_z WHERE d = $quo$%s$quo$ "
$B-!8!:wJ8;zNs(B=$B!V(B\$B!W!V$=$NB>J8;zNs!W(B
  $B8!:w2D(B
$B-"8!:wJ8;zNs(B=$B!V(BTEST:TEST$B!W(B
  $B%7%9%F%`%(%i!<H/@8!J(BToo few arguments in line xxx.$B!K(B

$B!Z=$@58e![(B
#define L_SQL_FORMAT "SELECT a, b, c FROM table_z WHERE d = '$quo$%s$quo$' "
$B-!8!:wJ8;zNs(B=$B!V(B\$B!W!V$=$NB>J8;zNs!W!V(BTEST:TEST$B!W(B
  $B8!:w%G!<%?$J$7$H$J$k!#(B

>>>>>>>>>>>>>>>>$B!Z3NG'![(B
$B!V%3%m%s!W$+$D!V!o!W%^!<%/$NJ8;zNs$r(Bwhere$B6g$G;XDj$G$-$k;vNc$O$"$j$^$9$+!)(B