Public Function Dbconnection(USER As String, PSWD As String, SOLDTO As String, USERSTRING As String, F As Boolean)
...
rsUSER.Open SQLstmt, PALEMEADBCon, adOpenDynamic, adLockOptimistic
...
If rsUSER.EOF Then
F = False
Else
...
End If
...
rsUSER.Open SQLstmt, PALEMEADBCon, adOpenDynamic, adLockOptimistic
...
If rsUSER.EOF Then
F = False
Else
...
End If
如果再次打开,应该先关闭
{
ADOQuery1->Close();
}
ADOQuery1->SQL->Clear();
ADOQuery1->SQL->Add("select * from yh where name=:name");
ADOQuery1->Parameters->ParamByName("name")->Value = "zhoucj";
ADOQuery1->Open();
呢?
{
ADOQuery1->First();
ADOQuery1->Close();
}
ADOQuery1->SQL->Clear();
ADOQuery1->SQL->Add("select * from yh where name=:name");
ADOQuery1->Parameters->ParamByName("name")->Value = "zhoucj";
ADOQuery1->Open();
pengdali(大力 V3.0)
if (ADOQuery->Active)
{
ADOQuery1->Close();
}
这个好象没什么必要,如果每次都家这个判断,那不是一个Query只能用一次?