Question

PB菜鸟急求数组的用法

string contile[]
contile[]=select pwd into :pwd from mian01;
谢了 但是你那代码是把PWD放在contile[]里了还是房在cur_pwd ?

Answer 1

string contile[],pwd
int i=1
declare cur_pwd cursor for select pwd from mian01;
open cur_pwd ;
fetch cur_pwd into :pwd ;
do while sqlca.sqlcode=0
contile[i]=pwd
i++
fetch cur_pwd into :pwd ;
loop
close cur_pwd;

Answer 2

他的代码是用游标将值取出，然后放到contile[]里。
有多少个pwd值数组的长度就是多少。

Answer 3

string contile[],pwd
int i=1
declare cur_pwd cursor for select pwd from mian01;
open cur_pwd ;
fetch cur_pwd into :pwd ;
do while sqlca.sqlcode=0
contile[i]=pwd
i++
fetch cur_pwd into :pwd ;
loop
close cur_pwd;