总出现类型不比配提示Type mismatch in expression
总出现类型不比配提示Type mismatch in expression
我的这段代码是
void __fastcall TfmLogin::Button1Click(TObject *Sender)
{
short count = 0;
if(Edit1->Text =="" || Edit2->Text =="")
{
ShowMessage("用户名或密码不能为空!");
return;
}
Query1->SQL->Clear();
Query1->SQL->Add("select count(*) as 数量");
Query1->SQL->Add("from Use.db");
Query1->SQL->Add("where 用户名=:id and 密码=:pwd and 权限级别=:qx");
Query1->Params->Items[0]->AsString = Edit1->Text.Trim() ;
Query1->Params->Items[1]->AsString = Edit2->Text.Trim() ;
Query1->Params->Items[2]->AsString = ComboBox1->Text.Trim();
Query1->ExecSQL();
Query1->Open();
count = Query1->FieldByName("数量")->AsInteger;
Query1->Close();
用paradox 做的表 表的结构是
用户名 S
密码 S
权限级别 A
这个是个登陆的代码 请问我应该改哪些地方 才能改正这个错误呢