How to pass a parameter from the server to the client in Datasnap?

Your webservice connects to your database and you use SQLconnection , SQLDataset , and Datasetprovider . In Commandtext of your sqldataset you entered something like

Select * from tabela where id =:id

In your mobile application, in your datamodule you put SQLConnection , drive datasnap, DSProviderconnection and even ClientDataSet , in the object inspector of ClientDataSet you set RemoteServer pro tu DSProviderConnection e no ProviderName set your datasetprovider there of your webservice .

In Params you create a new paramenter with the name of id , give it a value of 1 just to test, right-click on your clientdataset and click on FieldsEditor , click on right click on the white area of the new window and click on Add Fields , if you load all the fields of the table it is signal that everything is ok by passing correct parameter, delete the value of the parameter created in your clientdataset .

When you need to make a request using paramentro, just use:

 ParamByName('id').AsInteger := 1; 

To write the changed data that has been uploaded is that old story of Post and ApplyUpDates()

Hope it was useful

I do not know if I understood your question well, it's a bit confusing, but if that's what I understand, it's a very simple problem to solve, alias very primary. the client data x has to be parameterized somehow select * from table where client =: client

When you log in, you get some data from the client type id or anything and use it as a paramenter.

function getPefilUsuario(aUsuario, aSenha: string): Boolean;
begin
  with FQry_Pefil do
  begin
    Close;
    Params[0].AsString := UpperCase(aUsuario);
    Params[1].AsString := UpperCase(aSenha);
    Open;
    Result := (FQry_Pefil.RecordCount > 0);
  end;

If it's not that I'm sorry you're really confused the question