老是出错过来帮看看？

[panjinfu80]

select a.*,[b.name] as Name from Place a ,Area b where [a.AreaID]=[b.AreaID] and [b.AreaID] ='''+inttostr(NowAreaID)+''' order by a.PlaceID


'''+inttostr(NowAreaID)+''' 是赋值的（SQL语句），老是数据类型不匹配，AreaID整型，NowAreaID也是整型该什么转换如果是字符型又如何转换？

[samfeng_2003]

select a.*,[b.name] as Name from Place a ,Area b where [a.AreaID]=[b.AreaID] and [b.AreaID] =''+inttostr(NowAreaID)+'' order by a.PlaceID

这样试一试呢？

[panjinfu80]

ACCESS不像那样可以自动隐性转换数据类型的，有没有什么函数可以转换的？像字符型转换成整型的函数？

[panjinfu80]

ACCESS不像SQL那样可以自动隐性转换数据类型的，有没有什么函数可以转换的？像字符型转换成整型的函数？

[wwwwb]

inttostr()是DELPHI的函数，在ACCESS中，直接用&.
try:
select a.*,[b.name] as Name from Place a ,Area b where [a.AreaID]=[b.AreaID] and [b.AreaID] =''& NowAreaID +'' order by a.PlaceID

[changechange]

select a.*,[b.name] as Name from Place a ,Area b where [a.AreaID]=[b.AreaID] and [b.AreaID] ='''+inttostr(NowAreaID)+''' order by a.PlaceID

上述语句明显数据类型错误！

'''+inttostr(NowAreaID)+''' 的结果 [b.AreaID] = '某个字符串了'，比如[b.AreaID] = '1'
而正确的结果是 [b.AreaID] = 1

所以应该


'select a.*,[b.name] as Name from Place a ,Area b where [a.AreaID]=[b.AreaID] and [b.AreaID] =' + inttostr(NowAreaID) + ' order by a.PlaceID'

[fangshiguang]

如果你真的是在Delphi环境中，可以参考如下：
with adoqry do
begin
close;
sql.clear;
sql.add('select a.*,[b.name] as Name from Place a ,Area b where [a.AreaID]=[b.AreaID] and [b.AreaID] ='+inttostr(NowAreaID)+' order by a.PlaceID');
open;
end;