N
nbpj
Unregistered / Unconfirmed
GUEST, unregistred user!
1。用Delphi开发急于Access数据库的应用,但执行下面的SQL语句会提示“操作必须执行一个可执行的查询”的错误,
请问为什么,是因为Access不支持这样的SQL语句吗?
UPDATE Salary a SET Amount=(Select Salary_NR from Employee b where a.Employee_ID=b.Employee_ID)
where (a.Month_TX=_month)
and a.Employee_ID in (Select Employee_ID from Employee where Time_YN='Y')
2。Access数据库表的自动编号字段如何清零?
请问为什么,是因为Access不支持这样的SQL语句吗?
UPDATE Salary a SET Amount=(Select Salary_NR from Employee b where a.Employee_ID=b.Employee_ID)
where (a.Month_TX=_month)
and a.Employee_ID in (Select Employee_ID from Employee where Time_YN='Y')
2。Access数据库表的自动编号字段如何清零?