主题：表的字段

1、数据库人员表中字段都是英文的

2、查询功能中有一个需求，字段：组合框，组合框里面列出了姓名，年龄，性别等

3、如选择了姓名，但是数据库中对应的是name,查询表中的列名也是name,

如何让它显示成中文

1、你可以把表格添加到foxtable，然后设置列标题 http://www.foxtable.com/webhelp/scr/0036.htm

 

2、你也可以写代码处理 http://www.foxtable.com/webhelp/scr/1275.htm

 

3、你如果是些sql语句的，直接定义也可以，如 select name as 姓名, sex as 性别 from {表A}

此主题相关图片如下：1.png

 

Dim cs As String = ""
With e.Form.Controls("cmb")
      cs= .Value
End With

Dim jb1 As New SQLJoinTableBuilder("查询表1","person")
jb1.C
'jb1.AddCols("name", "sex","retireTime")
For Each s As String In cs.split(",")
    jb1.AddExp(s, s)
Next
jb1.Filter = Filter

 

1、用户字段选择了姓名、性别

2、红色语句提取到的是{姓名、性别}

3、蓝色语句实际应该输入的参数是数据库的字段{name,sex}

 

如何让用户输入汉字，但是能契合到数据库里面的name?

 

参考

 

Dim cs1() = {"第一列", "第二列", "第三列"}
Dim cs2() = {"name", "sex", "age"}

Dim cs = "第三列,第二列"
For Each  c As String In cs.split(",")
    Dim i = array.Indexof(cs1, c)
    msgbox(cs2(i))
Next

不是，最主要的是用户输入的中文，代码中要用到英文，怎么使得中文和英文一一对应

懂了

Dim cs1() = {"姓名", "性别", "年龄","身份证号","出生年月","联系电话","籍贯","民族","学历","健康状况","参加工作时间","政治面貌","兴趣爱好","离退休职务","享受待遇","地址",
             "状态","离退休时间","专业技术职务","专业特长","所在党支部","入党时间","个人成分","单位","党龄","离退休所在部门"}
Dim cs2() = {"name", "sex", "age","cardID","birth","birth","tel","jiguan","rational","edu","health","workdate","politicalStatus","hobbies","retiredPost","title","address",
             "leaOrRetire","retireTime","proTecPost","proSpecialty","partyBranch","partyTime","presonalClass","organName","partyStanding","retiredDep"}

 

这俩句有错提示应该是表达式

Dim cs1() = {"姓名", "性别", "年龄","身份证号","出生年月","联系电话","籍贯","民族","学历","健康状况","参加工作时间","政治面貌","兴趣爱好","离退休职务","享受待遇","地址", _
             "状态","离退休时间","专业技术职务","专业特长","所在党支部","入党时间","个人成分","单位","党龄","离退休所在部门"}
Dim cs2() = {"name", "sex", "age","cardID","birth","birth","tel","jiguan","rational","edu","health","workdate","politicalStatus","hobbies","retiredPost","title","address", _
             "leaOrRetire","retireTime","proTecPost","proSpecialty","partyBranch","partyTime","presonalClass","organName","partyStanding","retiredDep"}

 

http://www.foxtable.com/webhelp/scr/2489.htm

 

您好，如何让生成的查询表都居中？

列数据居中？参考

 

http://www.foxtable.com/webhelp/scr/1786.htm