🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: fj.lang.visualbasic
Article #1277

[Q] RDO problem with VB4

#1277
From: Yoshikazu Tabata
Date: Mon, 13 Oct 1997 00:00
37 lines
1910 bytes
$B$3$s$P$s$o!"EDH*!w0BF^Ln$H$$$$$^$9!#(J

VB4 E.E. $B$H(J Oracle $B$G(J RDO $B$r;H$C$?%"%W%j%1!<%7%g%s$r:n$C$F$$$^$9$,!"(J
$B4JC1$J(J OpenResultset $B$,$&$^$/F0$$$F$/$l$^$;$s!#=u$1$F2<$5$$$^$;$s$+!)(J

$B!!!!!!(J sql = "select user_name from table where user_id = '" +
Trim(Userid.Text) + "'"

$B!!!!!!(J rQuery = OpenResultset (sql)

$B$3$l$@$1$J$s$G$9$,!"$3$N(J table $B$K(J test $B$H$$$&(J user_id $B$,EPO?$5$l$F(J
$B$$$?>l9g!"%U%)!<%`$N(J Userid.Text $B$K(J TEST $B$HF~NO$7$F$3$N(J OpenResultset
$B$r<B9T$9$k$H!":FEY(J Userid.Text $B$K(J test $B$H>.J8;z$GF~NO$7$F$b(J select $BJ8$,(J
$B@5$7$$%l%3!<%I$r8+$D$1$k;v$,$G$-$^$;$s!#(J

ODBC $B$N%@%s%W$r8+$F$_$F$b!"(J

$B!!!!!!(J select user_name from table where user_id = 'TEST'

$B$r7+JV$7<B9T$7$F$$$k$h$&$G$9!#$3$l$O(J ODBC $B$N;EMM$J$N$G$7$g$&$+!)(J

$B0lC6(J RDO $B$N@\B3$r@ZCG$7$J$$$H$3$N>u67$O2sHr$5$l$^$;$s!#(J
$B$b$7B>$K$&$^$$J}K!$r$4B8$8$NJ}$,$$$i$C$7$c$$$^$7$?$i65$($F2<$5$$!#(J

$B$A$J$_$K(J ODBC $B%I%i%$%P$K$O(J InterSolv $B$N$b$N$H(J Oracle $B$N$b$N$H!"(J
$B$I$A$i$r;H$C$F$b>u67$OJQ$o$j$^$;$s$G$7$?!#(JOracle $B$O(J Workgroup
Server R7.3 $B$r(J NT3.51 Server $B$GF0$+$7!"%/%i%$%"%s%H$O(J NT4.0 Workstation
$B$G$9!#(J

$B$h$m$7$/$*4j$$$7$^$9!#(J

--
Yoshikazu Tabata
E-Mail: tabata@pop06.odn.ne.jp
$B!!(J
$B!!(J
Technical Details
Message-ID: <344226CD.1D32D50A@pop06.odn.ne.jp>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: Japanese,JIS
X-Google-Thread: 110a07,58719ceb928118e3,start
X-Google-Attributes: gid110a07,public
X-Google-Thread: 105c2e,58719ceb928118e3,start
X-Google-Attributes: gid105c2e,public
From: Yoshikazu Tabata <tabata@pop06.odn.ne.jp>
Subject: [Q] RDO problem with VB4
Date: 1997/10/13
Message-ID: <344226CD.1D32D50A@pop06.odn.ne.jp>
X-Deja-AN: 280233800
X-Priority: 3 (Normal)
Organization: Japan Telecom Co.,Ltd, Tokyo, Japan
Newsgroups: fj.lang.visualbasic,fj.os.ms-windows.programming