我有一个子程序如下
Public Sub updateStagesTable(sName As String, percentageValue As Double)
stageName = "'" & sName & "'"
sSQL = "INSERT INTO StagesT ([Stage Name], [Stage Value In Percentage]) VALUES (" & stageName & "," & percentageValue & ");"
DoCmd.SetWarnings False
DoCmd.RunSQL sSQL
End Sub
我从另一个子程序中调用它,如下所示
economy = 3.53
updateStagesTable ("Economy", economy)
但我收到这个编译错误
Compile Error: expected: =
我不明白我在这里做错了什么。请帮忙。
updateStagesTable ("Economy", economy)
应该
updateStagesTable "Economy", economy
没有括号
参见相关:typename 产生意外结果 https://stackoverflow.com/questions/22186853/unexpected-results-from-typename/22188933#22188933
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)