Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers