Jump to content

FDQuery in mobile project


Lena

Recommended Posts

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);
		   }
}

Link to comment
Share on other sites

×
×
  • Create New...