我在编程时遇到一个问题:就是要查询的图号中前三位与之匹配的
用下列语句不行:
Query1.Sql.add(SELECT * FROM MYTABLE WHERE DRAWING LIKE :STR2 );
Query1.Sql.Add('%');
HELP!!!
用下列语句不行:
Query1.Sql.add(SELECT * FROM MYTABLE WHERE DRAWING LIKE :STR2 );
Query1.Sql.Add('%');
HELP!!!
begin
close;
sql.Clear;
sql.Add('select * from danweibiao where dwmc like :dwmc');
Parameters[0].Value:='%'+edit1.text+'%';
open;
end;
'select * from tytable where drawing like ''%'+edit1.text+'%'''
就行了啊,把SQL语句弄出来看看
query1.sql.add(str2+'%''');
//str2在此处为一string型变量!
Query1.Sql.add(SELECT * FROM MYTABLE WHERE DRAWING LIKE :STR2 );
Parameters[0].AsString := Edit1.Text + '%';
Open;
NO.2:
Sql.Add:='SELECT * FROM MYTABLE WHERE DRAWING LIKE ' +#39 + str+ '%' +#39;
Open;
比较安全!
'SELECT * FROM MYTABLE WHERE DRAWING LIKE '+quotedstr(str+'%');
其中str是你要匹配的串的前三位!