1,178
社区成员
发帖
与我相关
我的任务
分享
try
{
String SqlStr,TableStr;
TableStr=DataMod->InsertTable->TableName;
SqlStr="Select top 10 * from "+TableStr;
SqlStr+=" Where Lane=1 order by VEH_ID Desc";
DataMod->DisplayQuery1->Close();
DataMod->DisplayQuery1->SQL->Clear();
DataMod->DisplayQuery1->SQL->Add(SqlStr);
DataMod->DisplayQuery1->Open();
DataMod->DisplayQuery1->First();
SqlStr="Select top 10 * from "+TableStr;
SqlStr+=" Where Lane<>1 order by VEH_ID Desc";
DataMod->DisplayQuery2->Close();
DataMod->DisplayQuery2->SQL->Clear();
DataMod->DisplayQuery2->SQL->Add(SqlStr);
DataMod->DisplayQuery2->Open();
DataMod->DisplayQuery2->First();
}
catch(...)
{
//
}
供参考