以文本方式查看主题 - Foxtable(狐表) (http://foxtable.net/bbs/index.asp) -- 专家坐堂 (http://foxtable.net/bbs/list.asp?boardid=2) ---- 数据源从ACCESS变更为MSSQL后,以下语句出错了 (http://foxtable.net/bbs/dispbbs.asp?boardid=2&id=195873) |
-- 作者:keli0917 -- 发布时间:2025/3/16 21:35:00 -- 数据源从ACCESS变更为MSSQL后,以下语句出错了 数据源从ACCESS变更为MSSQL后,以下语句出错了 cmd1.CommandText = "UP,D,,,ATE {GLVchFileAddress} , {凭证序时簿} SET {GLVchFileAddress}.FNum = {凭证序时簿}.凭证号码 ,{GLVchFileAddress}.FPeriod = {凭证序时簿}.期间 ,{GLVchFileAddress}.FDate = {凭证序时簿}.日期 WHERE {凭证序时簿}.[凭证号] = {GLVchFileAddress}.[凭证号]" cmd1.ExecuteNonQuery
|
-- 作者:keli0917 -- 发布时间:2025/3/16 21:35:00 -- \',\' 附近有语法错误。 |
-- 作者:有点蓝 -- 发布时间:2025/3/16 21:44:00 -- cmd1.CommandText = "update a SET a.FNum = b.凭证号码 ,a.FPeriod = b.期间 ,a.FDate =b.日期 from {GLVchFileAddress} as a inner join {凭证序时簿} as b on a.[凭证号] = b.[凭证号]" |