Error loading TWebClientDataSet

[Sergio_Cordeiro_Brandao (Sérgio Cordeiro Brandão)]

Hello,
An error occurs when I try to assign the WebClientDataSet a set of records where the first line contains a field equal to null. The command is WebCientDataSet1.Rows: = JS.ToArray (TJSJson.parse (AResponse));
If the null field is after the first line, the problem does not occur.
Browse error message: WebClientDataSet1: Field not found.
Note: Fields were created at design time

[brunofierens]

Is this with the latest version of TMS WEB Core?
So far, I could not see a reason for this nor reproduce this with the latest version.
From our code, we also do not have any error message "field not found", so not sure where this error message comes from. Did you add such message somewhere in your code?

[Walter_Javier_CepellottI]

Hello, I think the problem occurs with fields created at design mode. When the application runs it doesn't create the fields

I had a similar problem with 1.4.2 version, but I found a solution

Take a look at

Error WebClientdataset

Hello Please try this code: unit Unit1; interface uses System.SysUtils, System.Classes, JS, Web, WEBLib.Graphics, WEBLib.Controls, WEBLib.Forms, WEBLib.Dialogs, Data.DB, WEBLib.CDS; type TForm1 = class(TWebForm) cd: TWebClientDataSet; cdcad: TStringField; procedure WebFormCreate(Sender: TObject); private { Private declarations } public { Public declarations } end; var Form1: TForm1; implementation {$R *.dfm} procedure TForm1.WebFormCreate(Sender: TObject); begin cd.active:…

Perhaps you can solve your problem

[Sergio_Cordeiro_Brandao (Sérgio Cordeiro Brandão)]

Hello Bruno,
I use version 1.4.2.0.
The message is not implemented in my project.
I sent the project to support@tmssoftware.com
See mainform.pas source line 153

[Sergio_Cordeiro_Brandao (Sérgio Cordeiro Brandão)]

Hello @Walter_Javier_CepellottI

Thanks for the sugestion!
I haven't tested your suggestion, but I think it works.
In the meantime, I will await an official response from TMS.

[brunofierens]

Complemento is a TStringField and you try to load a JavaScript null value into this TStringField.
This isn't supported. null values cannot be used for string fields. Please return this in JSON as "" for empty strings.

[Sergio_Cordeiro_Brandao (Sérgio Cordeiro Brandão)]

Thanks Bruno,
It would be dangerous to change the json traffic rules on the server. I will make the option to create TWebClientDataSet fields at runtime. In this way, the error message does not occur.

[Steve_Sinclair]

I'm seeing a similar problem for a Boolean field with null values. Can null values be used for TBooleanField?

[brunofierens]

In Object Pascal, null isn't parsed to a bool true or false.