Lena Posted November 13, 2015 Posted November 13, 2015 Hi. v.1211 My SQL for FDQuery (FireDAC) return one record. Why FDQuery->RecordCount != ClientDataSet->RecordCount? FDConnection1->FDQueryRooms->DataSetProviderRooms->ClientDataSetRooms->DataSourceRooms void __fastcall TMainmForm::UnimDBGrid1Click(TObject *Sender) { try { UniMainModule()->FDQueryRooms->Active = false; UniMainModule()->ClientDataSetRooms->Active = false; UniMainModule()->FDQueryRooms->ParamByName(L"ORGANIZATIONSID")->AsInteger = UniMainModule()->ClientDataSetOrgan->FieldByName(L"id")->AsInteger; UniMainModule()->FDQueryRooms->Active = true; UniMainModule()->FDQueryRooms->FetchAll(); UniMainModule()->FDQueryRooms->First(); UniMainModule()->ClientDataSetRooms->Active = true; UnimFormRooms()->UnimDBGridRooms->HeaderTitle = L"Room in " + UniMainModule()->ClientDataSetOrgan->FieldByName(L"name")->AsString; if(UniMainModule()->FDQueryRooms->RecordCount == 0)//Why here RecordCount = 0? { ShowMessage(L"FDQueryRooms->RecordCount"); } if(UniMainModule()->ClientDataSetRooms->RecordCount == 0)//I see here RecordCount = 1 { ShowMessage(L"ClientDataSetRooms->RecordCount"); } } catch (const Exception &E) { String mis = L"Error: " + E.ClassName() + L" Mes: " + E.Message; ShowMessage(mis); } }
Recommended Posts