英文:
Why is this Calculation not giving me a result
问题
我创建了一个ExecuteSQL计算：
ExecuteSQL("SELECT BaseRent FROM obj_Unit_CurrentRenter_RentAmount WHERE RenterUnitID = ? AND CurRent = 1"; ""; ""; RenterUnitID)
我已经验证了，当我去掉 AND CurRent = 1 子句时它是有效的。然而，带有这部分的计算返回一个?。
CurRent是一个数字字段。
英文:
I created an ExecuteSQL Calculation:
ExecuteSQL ( "SELECT BaseRent FROM obj_Unit_CurrentRenter_RentAmount WHERE RenterUnitID = ? AND CurRent = 1" ; "," ; ""; RenterUnitID)
I've verified that is works when I take out the AND CurRent = 1 clause. However, with that part in it, the calculation returns a ?.
CurRent is a Number field.
答案1
得分: 1
问题在于你的字段名CurRent与保留字CURRENT冲突。
将你的公式更改为：
ExecuteSQL("SELECT BaseRent FROM obj_Unit_CurrentRenter_RentAmount WHERE RenterUnitID = ? AND \"CurRent\" = 1" ; "," ; ""; RenterUnitID)
英文:
The problem is that your field name CurRent collides with the reserved word CURRENT.
Change your formula to:
ExecuteSQL ( "SELECT BaseRent FROM obj_Unit_CurrentRenter_RentAmount WHERE RenterUnitID = ? AND \"CurRent\" = 1" ; "," ; ""; RenterUnitID)
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论