一条语句,在Access里能用,但在delphi的Adoquery里不能用。求解!
update 数据 as t1, (select 房屋详细地址, mid(房屋详细地址,InStr(房屋详细地址,"心")+1,(InStr(房屋详细地址,"会")+1)-(InStr(房屋详细地址,"心")+1)) as A2 from 数据 ) as t2 set t1.村居=t2.A2 where t1.房屋详细地址=t2.房屋详细地址
在Access的2010里能用,移到delphi的Adoquery里以后,却提示“无效的过程调用”。请问怎样解决?
谢谢!