P
Pipi.
Unregistered / Unconfirmed
GUEST, unregistred user!
where (hm like '_') or (hm like '__') or (hm like '___') or (hm is null)
or (hm='')
or (hm='')
P
pyk1
Unregistered / Unconfirmed
GUEST, unregistred user!
to Pipi.
您好，您的办法只能在QUERY的STRING属性中设置，可以通过，但我用
with query1 do
begin
close;
sql.clear;
sql.add('select * from test where (hm like '___')');
open;
end;
却通不过！
您好，您的办法只能在QUERY的STRING属性中设置，可以通过，但我用
with query1 do
begin
close;
sql.clear;
sql.add('select * from test where (hm like '___')');
open;
end;
却通不过！
S
structer
Unregistered / Unconfirmed
GUEST, unregistred user!
最后语句写的有误吧,like后应该加单引号吧。
with query1 do
begin
close;
sql.clear;
sql.add('select * from test where (hm like ''___'')');
open;
end;
with query1 do
begin
close;
sql.clear;
sql.add('select * from test where (hm like ''___'')');
open;
end;
K
Kingron
Unregistered / Unconfirmed
GUEST, unregistred user!
Pipi的方法虽然很笨，但是可以通过！起初我也这么想的。：）
P
Pipi.
Unregistered / Unconfirmed
GUEST, unregistred user!
sql.add('select * from test where (hm like ''___'')');
注意在' '里面2个连续的单引号等于1个单引号
注意在' '里面2个连续的单引号等于1个单引号
D
ddev
Unregistered / Unconfirmed
GUEST, unregistred user!
Select bh from table where hm like "___"
“_”是单字符通配符，如果数据库不一样，根据你的数据库规定。
“_”是单字符通配符，如果数据库不一样，根据你的数据库规定。
S
sinpo
Unregistered / Unconfirmed
GUEST, unregistred user!
关于字符串中单引号，可以这样解决
with query1 do
begin
close;
sql.clear;
sql.text:='select * from tablename where hm like
1';
params[0].asstring:='_';
open;
end;
with query1 do
begin
close;
sql.clear;
sql.text:='select * from tablename where hm like
1';params[0].asstring:='_';
open;
end;
P
pyk1
Unregistered / Unconfirmed
GUEST, unregistred user!
接受答案了.