字符串查询，我这样写对吗？(10分)

V

vpt

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-23

• #1

SQL Server数据库，在delphi中做查询，
admin是一个varchar属性的列，我要显示admin是tester1的列，但是下面的写法编译通不过。为什么？

procedure TForm1.Button2Click(Sender: TObject);
begin
With Query1 do
begin
Close;
SQL.Clear;
SQL.Add('select * from messagetable');
SQL.Add('Where Admin='Tester1'');
open;
end;
end;

 

W

wr960204

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-23

• #2

procedure TForm1.Button2Click(Sender: TObject);
begin
With Query1 do
begin
Close;
SQL.Clear;
SQL.Add('select * from messagetable');
SQL.Add('Where Admin=''Tester1''');//在这里
open;
end;
end;

 

一

一少

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-23

• #3

SQL.Clear;
SQL.Add('select * from messagetable');
SQL.Add('Where Admin=''Tester1''');

 

来

来如风

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-23

• #4

SQL.Add('Where Admin='Tester1'');//SQL.Add('Where Admin=''Tester1''');
//delphi中'前要加一个'

 

B

brown0432

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-23

• #5

sql.add('select * from messagetalbe where admin='+'tester1'');

 

V

vpt

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-23

• #6

真奇怪，是前面2个单引号，后面3个单引号。

 

填

填海精卫

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-23

• #7

1.记住字符串里2个引号相当于一个引号
2.记住两个sql语句间加个空格
3.建议查找字符时用like
example:

SQL.Clear;
SQL.Add('select * from messagetable ');//注意空格
SQL.Add('Where Admin=''Tester1''');

 

R

redleilei

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-23

• #8

这句错了：SQL.Add('Where Admin='Tester1'');

应该改为：SQL.Add('Where Admin=''Tester1''');