TWebCore and XDATA

The associations (joins) are defined in the model itself. You will have two classes, TUser and TLanguage, for example, and your class TUser will be something like this:

TUser = class

  ID: Integer;

  Name: string;

  Language: TLanguage;

Thus when you query your users, each user object will have a Language property with all the TLanguage data contained in it.

More info here: http://www.tmssoftware.biz/business/aurelius/doc/web/lazy-loading_associations.html

Thanky

Patrick

thank you for replay!

I realized the co0nnection between the TMS WeCore Project via the XDataServer to the database, before. That works. But I have problems with the needed SQL-statement-syntax. I like to use raw sql, like you mentioned before. 

Your post: ...  You can also, alternatively, just create service operation where you add your own business logic to it (using raw SQL server and using FDQuery, if you want) ...

How can I use raw sql in a project with TMS WebCore. Can I use it with the XData Server? 

In the documentation A could not find anything to FDQuery...

I have really problems to start working with it and I thank you for support!

Patrick

I was able to rebuild the example in my environment and it works nice with a vcl application. Afterwards I tried to rebuild it as a webapplication, but I failed. I get an error message in the included interface of the xdatawebservice:  "[Fehler] uData_xChangeService.pas(6): can't find unit "XData.Server.Module" 

and 

"[Fehler] uData_xChangeService.pas(7): can't find unit "XData.Service.Common"

Can you support me, to understand, what I have to do different?

Many thanks

This is the whole unit:

When I check the Response.ResponseText I can see, that the data are in.

When I try "XDS_Abteilung.SetJsonData(TJSArray(Response.Result));" nothing happens. I wanted to check an fieldvalue by:

But I get the error message: "EntitySetName not specified"

When I try fill the DataSet by 

"XDS_Abteilung.SetJsonData(TJSArray(TJSObject(Response.Result)['value']));"

I get the error message: Can not read property 'value' of null as OnResponse

Can you support me?

{"FDBS":{"Version":15,"Manager":{"UpdatesRegistry":true,"TableList":[{"class":"Table","Name":"Query_Main","SourceName":"abteilung","SourceID":1,"TabID":0,"EnforceConstraints":false,"MinimumCapacity":50,"ColumnList":[{"class":"Column","Name":"AbteilungsID","SourceName":"AbteilungsID","SourceID":1,"DataType":"UInt32","Precision":10,"Searchable":true,"AllowNull":true,"AutoInc":true,"Base":true,"AutoIncrementSeed":-1,"AutoIncrementStep":-1,"OAllowNull":true,"OInWhere":true,"OInKey":true,"OAfterInsChanged":true,"OriginTabName":"nedcom2.abteilung","OriginColName":"AbteilungsID","SourcePrecision":10},{"class":"Column","Name":"Abteilung","SourceName":"Abteilung","SourceID":2,"DataType":"AnsiString","Size":45,"Searchable":true,"Base":true,"OInUpdate":true,"OInWhere":true,"OriginTabName":"nedcom2.abteilung","OriginColName":"Abteilung","SourceSize":45},{"class":"Column","Name":"Test","SourceName":"Test","SourceID":3,"DataType":"AnsiString","Size":45,"Searchable":true,"Default":true,"Base":true,"OAllowNull":true,"OInUpdate":true,"OInWhere":true,"OAfterInsChanged":true,"OriginTabName":"nedcom2.abteilung","OriginColName":"Test","SourceSize":45}],"ConstraintList":[],"ViewList":[],"RowList":[{"RowID":0,"Original":{"AbteilungsID":10,"Abteilung":"Verkauf","Test":"0"}},{"RowID":1,"Original":{"AbteilungsID":20,"Abteilung":"Anwendung & Entwicklung","Test":"0"}},{"RowID":2,"Original":{"AbteilungsID":30,"Abteilung":"Technische B?ro","Test":"0"}},{"RowID":3,"Original":{"AbteilungsID":40,"Abteilung":"Arbeitsvorbereitung","Test":"0"}},{"RowID":4,"Original":{"AbteilungsID":50,"Abteilung":"Produktion","Test":"0"}},{"RowID":5,"Original":{"AbteilungsID":60,"Abteilung":"Werkzeugbau","Test":"0"}},{"RowID":6,"Original":{"AbteilungsID":70,"Abteilung":"Einkauf","Test":"0"}},{"RowID":7,"Original":{"AbteilungsID":80,"Abteilung":"Qualit?tssicherung","Test":"0"}},{"RowID":8,"Original":{"AbteilungsID":90,"Abteilung":"EDV","Test":"0"}},{"RowID":9,"Original":{"AbteilungsID":100,"Abteilung":"Finanzbuchhaltung","Test":"0"}},{"RowID":10,"Original":{"AbteilungsID":110,"Abteilung":"Gesch?ftsf?hrung","Test":"0"}},{"RowID":11,"Original":{"AbteilungsID":111,"Abteilung":"PM","Test":"0"}}]}],"RelationList":[]}}}

I tried it on this way:

But I get the error-message:  Cannot read property 'FDBS.Manager.TableList.RowList' of null at OnResponse

thanks for support! I defined the fields and changed my procedure like you descripted:

But unfortunally I get an error-message, like before:

What can be caused the error?

Greetings from Germany

Patrick

1. The server response is configured as a TStream. Thus, the result will always come, in web core, as a string. This is what you need to correctly parse the result:

JFDBS := TJSObject(TJSObject(TJSJson.Parse(string(Response.Result)))['FDBS']);       JManager := TJSObject(JFDBS['Manager']);       JTableList := TJSObject(TJSArray(JManager['TableList'])[0]);       JRowList := TJSArray(JTableList['RowList']);       console.log(JRowList);

2. In your JSON result, TableList is an array, not an object. Thus you need to get the first item of an array (I’m not sure what you should do if you have two items in the array, but that is specific to your application):

JFDBS := TJSObject(TJSObject(TJSJson.Parse(string(Response.Result)))['FDBS']);       JManager := TJSObject(JFDBS['Manager']);       JTableList := TJSObject(TJSArray(JManager['TableList'])[0]);       JRowList := TJSArray(JTableList['RowList']);       console.log(JRowList);

3. Since in your JSON result the actual data come in a subject (Original):

"RowList": [{                     "RowID": 0,                     "Original": {                         "AbteilungsID": 10,                         "Abteilung": "Verkauf",                         "Test": "0"                     }                 },

You need to create your dataset fields with field name prefixed with "Original.", e.g.:

Original.AbteilungsID

Original.Abteilung

Original.Test