sql查询问题(50分)

pandame · 2006-12-09

我在combobox3输入南京路65号，我想查询出road.name为“南京路”的路段的记录

s1:='select * from roads,do
orplate where (doorplate.ID = roads.ID) and ( name like '''+'%'+(combobox3.text)+'%'+''') ORDER BY roads.MAPINFO_ID';
这语句从语法上看没错吧？可是我怎么就是查询不出东西来呢？

sunnyfairy · 2006-12-09

有错误提示吗?字段列(Name)明确吗? 去查询分析器里执行一下吧

qizhao_2001 · 2006-12-09

你这样子是查name字段包含combobox3.text的记录，当然查不出来了

suger · 2006-12-09

s1:='select * from roads,do
orplate where (doorplate.ID = roads.ID) and ('''+'%'+(combobox3.text)+''' like name +'%')

Corn3 · 2006-12-09

name改成[name]

pandame · 2006-12-09

谢谢大家给我支招，我来试试~

pandame · 2006-12-09

s1:='select * from roads,do
orplate where (doorplate.ID = roads.ID) and ('''+'%'+(combobox3.text)+''' like name +'%')';
我改成这样后，它报这样的错：
[Error] searchUnit.pas(109): Illegal character in input file: '%' ($25)
怎么会这样呢？

wwhnet · 2006-12-09

s1:='select * from roads,do
orplate where (doorplate.ID = roads.ID) and ( name like ''%'+trim(combobox3.text)+'%''') ORDER BY roads.MAPINFO_ID'

wwhnet · 2006-12-09

s1:='select * from roads,do
orplate where (doorplate.ID = roads.ID) and ( name like '''%'+trim(combobox3.text)+'%''') ORDER BY roads.MAPINFO_ID'
不好意思，刚刚少了一个'

pandame · 2006-12-09

sql查询问题(50分)

pandame

Unregistered / Unconfirmed

sunnyfairy

Unregistered / Unconfirmed

qizhao_2001

Unregistered / Unconfirmed

suger

Unregistered / Unconfirmed

Corn3

Unregistered / Unconfirmed

pandame

Unregistered / Unconfirmed

pandame

Unregistered / Unconfirmed

wwhnet

Unregistered / Unconfirmed

wwhnet

Unregistered / Unconfirmed

pandame

Unregistered / Unconfirmed

Similar threads