TWEbRadServerClientDataSet Not Returning all field Values

[Barrow_Larry]

I have experienced trouble getting the TWebRadServerClientDataSet to populate all the fields returned. Is there a known bug, or fix?

Configuration is very basic... When I use equivalent components in VCL mode, all data is returned, just not with this TMS dataset :

Problem:

Full dataset is returned when isolated from the TMS component:

[image]

Delphi/TMS configuration:

[image]

Event for login btn:

procedure TForm6.WebButton1Click(Sender: TObject);

begin

// load vendors here

radServer.RadServerURL := 'http://localhost:8080';

radServer.TableName := 'data/sales/';

radServer.KeyFieldName := 'Sales_id';

radServer.FieldDefs.Clear;

radServer.FieldDefs.Add('Sales_id', ftinteger);

radServer.FieldDefs.Add('product_Code',ftString);

radServer.FieldDefs.Add('Product_Name',ftString);

radServer.FieldDefs.Add('Cust_no',ftString);

radserver.Login(edtUsername.Text, edtPassword.Text);

Azure SQL Config:

[image]

Any assistance is appreciated in advance.

[brunofierens]

Did you inspect the JSON returned by RAD server? This should typically be a JSON array and the values in the JSON array should be mapped onto the dataset fields.

[Barrow_Larry]

Your direct reply in another channel reminded me that the JSON attribute references are case sensitive. That was the issue. I matched cases in all the code and got the expected results. Thanks for your prompt reply.