SQL语句在BCB中的问题~~！(20分)

C

cool133

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-05-13

• #1

ADOQuery1->Close();
ADOQuery1->SQL->Clear();
Edit1->Text=ADOQuery1->SQL->Add("select '出发城市' from dbo.Table2 where '车次'='T89'");
ADOQuery1->Open();
运行后Edit1显示结果为0 ~
但实际在数据表中应该是 长沙

 

C

cwmdelpher

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-05-13

• #2

ADOQuery1->Close();
ADOQuery1->SQL->Clear();
ADOQuery1->SQL->Add("select '出发城市' from dbo.Table2 where '车次'='T89'");
ADOQuery1->Open();
Edit1->text = ADOQUERY->FieldByName('出发城市')->asstring ;

 

X

xzh2000

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-05-13

• #3

adoquery1->open();
Edit1->Text=Adoquery1->fields[0]->asstring;

 

L

lvxq

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-05-13

• #4

ADOQuery1->Close();
ADOQuery1->SQL->Clear();
ADOQuery1->SQL->Add("select '出发城市' from dbo.Table2 where 车次='T89'");
ADOQuery1->Open();
Edit1->text = ADOQUERY->FieldByName('出发城市')->asstring ;
车次是字段名么？干吗用单引号？

 

S

sevagegoden

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-05-13

• #5

ADOQuery1->SQL->Add("select 出发城市 from dbo.Table2 where 车次='T89'");

 

C

cool133

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-05-13

• #6

多人接受答案了。