SQL语句为什么报错？

[foxd]

Select Str(Round(Detail_Week1_Weight/(BasicInfo_Height*BasicInfo_Height),2)) as Detail_Week1_BMI from tb_Detail where Detail_No = 'LD-001-001'

报错：至少一个参数没有被指定值。

[gxingmin]

你SqlCommand.Parameters里有指定的参数没有赋值吧

[foxd]

说明一点：数据库是Access 2003的。

[Journey_ZZ]

Select Str(Round(Detail_Week1_Weight/(BasicInfo_Height*BasicInfo_Height),2)) as Detail_Week1_BMI from tb_Detail where Detail_No = 'LD-001-001'

-红色的仔细看看

[thunderwolf]

里面的字段会不会有null值

[gxingmin]

是不是字段名称写错了？
Detail_Week1_Weight?
BasicInfo_Height?