treeview的问题
假设数据库group name
1 a
2 b
3 c
1 d
1 e
. .
. .
在TV的第一层上检索到不重复的group。想在第二层上加入相应group字段的name,如何处理?
以下是我的代码:
long root,root2int i,row,j,row2string sql,err,sy,group[],sql2,err2,sy2,group2[]datastore ds,ds2dwobject dwo,dwo2ds=create datastoresql="select distinct group from AddressBook"sy=sqlca.syntaxfromsql( sql,'style(type=grid)',err)ds.create( sy, err) ds.settransobject(sqlca)ds.retrieve()ds2=create datastoredwo = ds.Object.__get_attribute('group', TRUE)group = dwo.Primaryrow=ds.rowcount( )root=tv_1.finditem(roottreeitem!,0)tv_1.deleteitem(root)root=tv_1.insertitemlast(0,"我的通讯记录",0)for i=1 to row root2=tv_1.insertitem(root,1,group[i],0) sql="select name from AddressBook where group=:group[i]"//怀疑是不是这句出了问题? sy2=sqlca.syntaxfromsql( sql2,'style(type=grid)',err2) ds2.create( sy2, err2) ds2.settransobject(sqlca) ds2.retrieve() row2=ds2.rowcount( )//用messagebox查看row2的值是0 dwo2=ds2.object.__get_attribute('name',true)//这行编译时没问题,在运行程序时提示null object reference group2 = dwo2.Primary for j=1 to row2 tv_1.insertitem(root2,1,group2[j],0) nextnext