🚀 go-pugleaf

Yoshikazu Tabata <tabata@pop06.odn.ne.jp> wrote in article
<344226CD.1D32D50A@pop06.odn.ne.jp>...
> $B$3$s$P$s$o!"EDH*!w0BF^Ln$H$$$$$^$9!#(B

$B$I$&$b!"(BMedia io$B!J%a%G%#%"!&%$%*!K(B $B$N(B Masaya Hirano$B$H?=$7$^$9!#(B

> 
> VB4 E.E. $B$H(B Oracle $B$G(B RDO $B$r;H$C$?%"%W%j%1!<%7%g%s$r:n$C$F$$$^$9$,!"(B
> $B4JC1$J(B OpenResultset $B$,$&$^$/F0$$$F$/$l$^$;$s!#=u$1$F2<$5$$$^$;$s$+!)(B
> 
> $B!!!!!!(B sql = "select user_name from table where user_id = '" +
> Trim(Userid.Text) + "'"
> 
> $B!!!!!!(B rQuery = OpenResultset (sql)
> 
> $B$3$l$@$1$J$s$G$9$,!"$3$N(B table $B$K(B test $B$H$$$&(B user_id $B$,EPO?$5$l$F(B
> $B$$$?>l9g!"%U%)!<%`$N(B Userid.Text $B$K(B TEST $B$HF~NO$7$F$3$N(B OpenResultset
> $B$r<B9T$9$k$H!":FEY(B Userid.Text $B$K(B test $B$H>.J8;z$GF~NO$7$F$b(B select $BJ8$,(B
> $B@5$7$$%l%3!<%I$r8+$D$1$k;v$,$G$-$^$;$s!#(B
> 
> ODBC $B$N%@%s%W$r8+$F$_$F$b!"(B
> 
> $B!!!!!!(B select user_name from table where user_id = 'TEST'
> 
> $B$r7+JV$7<B9T$7$F$$$k$h$&$G$9!#$3$l$O(B ODBC $B$N;EMM$J$N$G$7$g$&$+!)(B
> 
> $B0lC6(B RDO $B$N@\B3$r@ZCG$7$J$$$H$3$N>u67$O2sHr$5$l$^$;$s!#(B
> $B$b$7B>$K$&$^$$J}K!$r$4B8$8$NJ}$,$$$i$C$7$c$$$^$7$?$i65$($F2<$5$$!#(B
>
> $B$A$J$_$K(B ODBC $B%I%i%$%P$K$O(B InterSolv $B$N$b$N$H(B Oracle $B$N$b$N$H!"(B
> $B$I$A$i$r;H$C$F$b>u67$OJQ$o$j$^$;$s$G$7$?!#(BOracle $B$O(B Workgroup
> Server R7.3 $B$r(B NT3.51 Server $B$GF0$+$7!"%/%i%$%"%s%H$O(B NT4.0 Workstation
> $B$G$9!#(B

$B40A4$J2rEz$G$J$/$F?=$7Lu$J$$$N$G$9$,!">e5-8=>]$O!"(BOracle$B$H(B
$B$$$&$h$j$b!"(BRDO$B$N;EMM$+$b$7$l$^$;$s!#(B

RDO$B$O(BSQL$B$r<B9T$9$k$H$-$K!"%G%U%)%k%H$G$O%9%F!<%H%a%s%H%O%s%I%k(B
$B$r#2$D%*!<%W%s$7!"(BrdoResultset$B$r%/%m!<%:$7$F$b!"#1$D$@$1$7$+%O(B
$B%s%I%k$r2rJ|$7$^$;$s!#$3$l$O!"7+$jJV$7F1Ey$N(BSQL$B$,<B9T$5$l$?>l9g(B
$B$3$N%9%F!<%H%a%s%H%O%s%I%k$r;HMQ$9$k$3$H$G!"%Q%U%)!<%^%s%9$r8~>e(B
$B$9$k0Y$+$H;W$o$l$^$9!#(B

$B;d<+?.$O!"1?NI$/(B(?)$BF1$88=>]$K=P$/$o$7$?$3$H$O$"$j$^$;$s$,!">e5-(B
$BJ8>O$rFI$`8B$j!"$3$N!VF1Ey$N(BSQL$B!W$+$I$&$+$rH=CG$9$k$N$K!"(BRDO$B$O(B
$BJ8;z$NBg>.$r0U<1$7$F$J$$$h$&$G$9$M(B(^^;$B!#(B

$B$G!"$3$l$G>e5-LdBj$,2r7h$5$l$k$+$I$&$+$O!"Dj$+$G$O$J$$$N$G$9$,!"(B
OpenResultset $B$N%*%W%7%g%s$K(B rdExecDirect $B$r;XDj$9$k$H(BRDO$B$O(B
$B%9%F!<%H%a%s%H%O%s%I%k$r#2$D%*!<%W%s$7$J$/$J$j$^$9!#(B
$B!J0x$_$K!"$3$N%*%W%7%g%s$O(B $B#V#B$N%X%k%W$N(B OpenResultset$B$N9`$K(B
$B$O5-:\$5$l$F$J$$$/$;$K!"(BrdoConnection$B!"(BrdoPreparedStatement
$B$N%l%Y%k$G$O!"@_Dj$,L5;k$5$l$^$9!#$5$9$,#M#S!*!*(B(^^;$B!K(B

$B>e5-J}K!$G$b%@%a$J$i!"(Buser_id$B$rBgJ8;z$@$1$+!">.J8;z$@$1$K@)8B(B
$B$7$F!"(BUserid.text$B$K(B UCase$B$+!"(BLCase$B$+$1$A$c$&$H$+!&!&!&(B(^^;$B!#(B

$B>/$7$G$b!"3+H/$N$*Lr$KN)$F$l$P9,$$$G$9!#(B

--------------------------------------------------------------------
Media io _ Masaya Hirano
mailto:masayah@mbox.kyoto-inet.or.jp
http://web.kyoto-inet.or.jp/people/masayah/
--------------------------------------------------------------------