Speed MemDataTable

Data Abstract
5

I’ve already shown how to create DataParameterArray at SQL: Select With WHERE clause :

//  par: DataParameterArray;
//  dp: DataParameter;

  par := DataParameterArray.Create;
  dp := par.Add;
  dp.Name := UTF8Encode('param1');
  dp.Value := 1;
  lRemoteDataAdapter.FillWithDASql(lTable,DASQL1, par);

here you need to pass array of DataParameterArray as 3rd parameter of FillWithDASql:

ClientDataModule.RemoteDataAdapter.FillWithDASql(
    [DM_reports.tbl_rep_camps, DM_reports.tbl_rep_default,
     DM_reports.tbl_rep_default_c,
     DM_reports.tbl_rep_default_d, DM_reports.tbl_rep_default_d],
    ['SELECT * FROM CAMPS', 'SELECT * FROM HOTEL',
     'SELECT * FROM HOTEL_C',
     'SELECT * FROM HOTEL_D', 'SELECT * FROM HOTEL_DD'], 
    [par1, par2, par3, par4, par5]);