我要将一个表中的某字段值更新到另一个表中,代码如下:
Dim db As Database
Set db = Workspaces(0).OpenDatabase(App.Path & "\luo") '打开数据库
Dim sql1 As String
sql = "update luo2 set luo2.sl=luo2.sl+luo1.sl where luo2.num=luo1.num"
db.Execute sql
总是提示参数不足,为什么??此SQL语句如何用?SQL测试也提示参数
Dim db As Database
Set db = Workspaces(0).OpenDatabase(App.Path & "\luo") '打开数据库
Dim sql1 As String
sql = "update luo2 set luo2.sl=luo2.sl+luo1.sl where luo2.num=luo1.num"
db.Execute sql
总是提示参数不足,为什么??此SQL语句如何用?SQL测试也提示参数
update luo2 set luo2.sl=luo2.sl+ (select sl from luo1 where luo2.num=luo1.num)
楼上的语句可以解决!另外也可以用
update luo2 set luo2.sl=luo2.sl+luo1.sl from luo2 left join luo1 on luo2.num=luo1.num
Me.Moveable=Falseme.BorderStyle=5 '不能最大最小化,但可以改变大小
Me.Moveable=False
SQL语句错误,更新1个表,牵扯2个表,是不能那样写的~~ 上面的兄弟已经提供答案了,我只是没事说说,看能不能混到分而已,哈哈~
Dim db As Database
Set db = Workspaces(0).OpenDatabase(App.Path & "\luo") '打开数据库
Dim sql1 As String
sql = "update luo2 set luo2.sl=luo2.sl+luo1.sl from luo2 left join luo1 on luo2.num=luo1.num"
db.Execute sql
总是提示语法错,为什么??此SQL语句如何用?
db.execute (sql)
sql="update luo2 set luo2.sl=luo2.sl+luo1.sl where luo2.num=luo1.num"
db.execute sql
db.execute sqldb.execute "delete from luo2"
db.execute "insert into lou2 select * from tmp"
db.execute "drop table tmp"
db.execute sqldb.execute "delete from luo2"
db.execute "insert into lou2 select * from tmp"
db.execute "drop table tmp"
update luo2 set luo2.sl=luo2.sl+(select sl from luo1 where luo1.num=luo2.num)