注册 登录
编程论坛 VFP论坛

请教一个sql语法

hytizj023 发布于 2023-04-09 15:57, 754 次点击

tongji="lingling,lingyi,linger,lingsan,lingsi,lingwu,lingliu,lingqi,lingba,lingjiu,"+;
"shiyi,shier,shisan,shisi,shiwu,shiliu,shiqi,shiba,shijiu,ershier,ershisan,ershisi,"+;
"ershiwu,ershiliu,ershiqi,ershiba,ershijiu,sanshisan,sanshisi,sanshiwu,sanshiliu,"+;
"sanshiqi,sanshiba,sanshijiu,sishisi,sishiwu,sishiliu,sishiqi,sishiba,sishijiu,"+;
"wushiwu,wushiliu,wushiqi,wushiba,wushijiu,liushiliu,liushiqi,liushiba,liushijiu,"+;
"qishiqi,qishiba,qishijiu,bashiba,bashijiu,jiushijiu"

sqlexec(nHandle,"select tongji from 历史统计双飞","历史统计双飞")&&这句有错,请教该怎么写
2 回复
#2
csyx2023-04-09 17:21
sqlexec(nHandle,"select ' + tongji + ' from 历史统计双飞","历史统计双飞")
#3
hytizj0232023-04-09 17:47
以下是引用csyx在2023-4-9 17:21:06的发言:

sqlexec(nHandle,"select ' + tongji + ' from 历史统计双飞","历史统计双飞")

是"+tongji+"
感谢
1