請教各位高手!
我想將Edit鍵入的keyword在各欄位搜尋，
若找到類似的字就在DBGrid顯示出來，
小弟有寫一些，但有些盲點，
不知如何著手!請各位大大幫忙!!
(b值為各欄位，if 的部份若欄位值有和keyword相同的話)
[code cpp]
String a = "%" Edit1->Text "%";
String b[7];
b[1]="m_name";
b[2]="m_address";
b[3]="m_tel";
b[4]="m_birth";
b[5]="m_ID";
b[6]="m_sex";
int i;
for(i=0;i<=6;i ){
ADOQuery1->SQL->Add("select * from member where '" b[i] "' like '" a "'");
if(ADOQuery1 == Edit1->Text)
{ ADOQuery1->Open();
DBGrid1->DataSource=DataSource1;
}
}
[/code]

[code cpp]
String a = "%" Edit1->Text "%";
String b[6];
b[0]="m_name";
b[1]="m_address";
b[2]="m_tel";
b[3]="m_birth";
b[4]="m_ID";
b[5]="m_sex";
int i;
for(i=0;i<=5;i )
{
ADOQuery1->Close();
ADOQuery1->SQL->Clear();
ADOQuery1->SQL->Add("select * from member where '" b[i] "' like '" a "'");
ADOQuery1->Open();
if ( ADOQuery1.FieldByName("YourCol")->AsString == Edit1->Text )
{
// process your dataset here.
}
}
[/code]

感謝Stallion版主回應!
不過我試完，似乎不太能用耶!
我將"YourCol"改成b[i] (YourCol是一個元件或欄位名還是指令嗎= =?)
// process your dataset here.
keyin→DBGrid1->DataSource=DataSource1;
不曉得是我誤會版主大大的意思，還是如何?
所以，在執行上有出現錯誤!無法搜尋!
嘗試許久也都是找不到或錯誤!><
另因為我是Borland c ADOQUERY是以"->"取代"."
但這應該沒差異!

===================引 用 Stallion 文 章===================
[code cpp]
if ( ADOQuery1.FieldByName("YourCol")->AsString == Edit1->Text )
{
// process your dataset here.
}
}
[/code]

[code cpp]
String a = "%" Edit1->Text "%";
String b[6];

b[0]="m_name";
b[1]="m_address";
b[2]="m_tel";
b[3]="m_birth";
b[4]="m_ID";
b[5]="m_sex";

for(int i=0;i<=5;i )
{
ADOQuery1->Close();
ADOQuery1->SQL->Clear();
ADOQuery1->SQL->Add("select " b[i] " from member where " b[i] " like " a);
ADOQuery1->Open();
if ( ADOQuery1->RecordCount() > 0 )
{
// process your dataset here.
}
}
[/code]

編輯記錄

請問版大!
RecordCount的功能是什麼阿?
是指將搜尋到值的筆數紀錄下來若大於0
就執行步驟嗎?
似乎是這部份會有問題!
出現句法錯誤的視窗(可執行但搜尋時就錯誤)
(不好意思!新手學習!請版大指教!)