pb环境下
string ycrq
ycrq='2009-05-31'
UPDATE du9yongdiantz_cx
SET ychd = gaodian, ycpd = pingdian, ycgd = gudian
FROM du9yongdiantz_cx a , du9yongdianjl b
WHERE a.chejian = a.chejian AND CONVERT(char(10), b.riqi, 20) = :ycrq
using sqlca; B表的字段替换A表的字段,
提示错误‘列前缀B与插询表中所用的表明或别名不匹配’
不知有何错误,如何修改?
string ycrq
ycrq='2009-05-31'
UPDATE du9yongdiantz_cx
SET ychd = gaodian, ycpd = pingdian, ycgd = gudian
FROM du9yongdiantz_cx a , du9yongdianjl b
WHERE a.chejian = a.chejian AND CONVERT(char(10), b.riqi, 20) = :ycrq
using sqlca; B表的字段替换A表的字段,
提示错误‘列前缀B与插询表中所用的表明或别名不匹配’
不知有何错误,如何修改?
ycrq='2009-05-31'
UPDATE du9yongdiantz_cx
SET ychd = gaodian, ycpd = pingdian, ycgd = gudian
FROM du9yongdiantz_cx a , du9yongdianjl b
WHERE a.chejian = B.chejian AND CONVERT(char(10), b.riqi, 20) = :ycrq
using sqlca;
其他的语法不懂
string ycrq
ycrq='2009-05-31'
UPDATE a
SET a.ychd = b.gaodian, a.ycpd = b.pingdian, a.ycgd = b.gudian
FROM du9yongdiantz_cx a , du9yongdianjl b
WHERE a.chejian = a.chejian AND CONVERT(char(10), b.riqi, 20) = :ycrq
using sqlca;
UPDATE a
SET
ychd = b.gaodian, ycpd = b.pingdian, ycgd = b.gudian
FROM
du9yongdiantz_cx a , du9yongdianjl b
WHERE
a.chejian = b.chejian AND CONVERT(char(10), b.riqi, 20) = :ycrq
ycrq='2009-05-31'
UPDATE a
SET a.ychd = b.gaodian, a.ycpd = b.pingdian, a.ycgd = b.gudian
FROM du9yongdiantz_cx a , du9yongdianjl b
WHERE a.chejian = b.chejian AND CONVERT(char(10), b.riqi, 20) = :ycrq
using sqlca;
string ycrq
ycrq='2009-05-31'
UPDATE du9yongdiantz_cx
SET ychd = gaodian, ycpd = pingdian, ycgd = gudian
FROM du9yongdiantz_cx a , du9yongdianjl b
WHERE a.chejian = b.chejian AND CONVERT(char(10), b.riqi, 20) = :ycrq
using sqlca;
两个表du9yongdiantz_cx 和du9yongdianjl
开头写的有误
SET a.ychd = b.gaodian, a.ycpd = b.pingdian, a.ycgd = b.gudian
FROM du9yongdiantz_cx a,du9yongdianjl b
WHERE a.chejian = b.chejian AND CONVERT(char(10), b.riqi, 20) = :ycrq
using sqlca;
用此语句也报错‘对象a 不存在’