Question

vfp 组合框问题

请教..我想让2个组合框显示2个表里的字段

WITH thisform.combo1
.rowsourcetype=3
.rowsource="select 姓名 from shiyany into cursor bfcyr order by 姓名"
.selected(1)=.t.
ENDWITH

WITH thisform.combo2
.rowsourcetype=3
.rowsource="select 性别 from shiyany2 into cursor bfcyr order by 性别"
.selected(1)=.t.
ENDWITH
运行后发现俩个组合狂一样的内容有什么办法可以让他们分别显示呢

Answer 1

WITH thisform.combo2
.rowsourcetype=3
.rowsource="select DISTINCT 性别 from shiyany into cursor bfcyr2 order by 性别"
.selected(1)=.t.
ENDWITH