SQL如下: SELECT ExamProject.projectID, ProjectFee.PriceListID, ProjectFee.Amount, ProjectFee.Standard, ProjectFee.Unit FROM ExamProject LEFT OUTER JOIN ProjectFee ON ExamProject.SheetID = ProjectFee.SheetID AND ExamProject.SerialID = ProjectFee.SerialID WHERE (ExamProject.SheetID = '00019764620070110100618')
以便查找出错原因
顺带:我没有遇到过lz所说的情况
SELECT ExamProject.projectID, ProjectFee.PriceListID, ProjectFee.Amount, ProjectFee.Standard, ProjectFee.Unit FROM ExamProject LEFT OUTER JOIN ProjectFee ON ExamProject.SheetID = ProjectFee.SheetID AND ExamProject.SerialID = ProjectFee.SerialID WHERE (ExamProject.SheetID = '00019764620070110100618')
代表什么错?SQL帮助里为什么没有?
try
{
DataModule_Share->ClientDataSet_InsertDelete3->Close();
DataModule_Share->ClientDataSet_InsertDelete3->SQL->Clear();
DataModule_Share->ClientDataSet_InsertDelete3->SQL->Add(sSQL);
DataModule_Share->ClientDataSet_InsertDelete3->Open();
}
catch(Exception&e)
{
throw;
}
//e.Message的内容就是SQL State: 08S0 , SQL Error Code: 0
//我要是不用try...catch抓错,也会抛出内容为SQL State: 08S0 , SQL Error Code: 0的异常