关于Recordset设置组合框字段排序

时　间:2015-07-09 17:30:09
作　者:Qiu J.X.   ID：1455  城市：龙岩
摘　要:Recordset设置组合框字段出现的顺序并不是SQL写的顺序，而是按字段名的字符排序。
正　文:

    mySQL = "Select [ZhongXInSN],[companyName] FROM [tblZhongXin] orDER BY ZhongXingID"
     Set Me.qCompany.Recordset = OpenADORecordset(mySQL)

上面代码设置组合框数据后，一般人都认为[ZhongXInSN]应该是在[companyName]前面，可是事实却不是这样：

mySQL = "Select [ZhongXInSN],[companyName] FROM [tblZhongXin] orDER BY ZhongXingID"
'改成
mySQL = "Select [ZhongXInSN] as 1,[companyName] as 2 FROM [tblZhongXin] orDER BY ZhongXingID"

顺序才对：

由此可见Recordset设置组合框字段出现的顺序并不是SQL写的顺序，而是按字段名的字符排序。