Skip to Content
0

How to save data in .xsodata service for dependent tables(Header& Item or Parent/Child) ?

Nov 07, 2017 at 02:05 PM

12

avatar image
Former Member

I am facing trouble while saving data of dependent tables

Table #1:

==========

OrderHeader {

OrderId Integer, // It is generated through Sequence

OrderDesc varchar(100)

}

Table #2:

===========

OrderItem {

OrderId Integer, // It is generated through Sequence

ItemId Integer,

OrderDesc varchar(100)

}

myservice.xsodata

===============

service {

"mySchema"."OrderHeader" as "ordHdr"

create using "<pkg>"::"CreateHdrProcedure"

update using "<pkg>"::"UpdateHdrProcedure"

delete using "<pkg>"::"DeleteHdrProcedure";

"mySchema"."OrderItem" as "ordItm"

create using "<pkg>"::"CreateItmProcedure"

update using "<pkg>"::"UpdateItmProcedure"

delete using "<pkg>"::"DeleteItmProcedure";

}

Here, How can i pass generated key(OrderId) to OrderItem to fill it in. Curretly i am using ODATA Batch request?

Please help on this issue

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers