Respected sir,

Providing Corrected one line from previous mail.Forgot to mention column
name there.

Id_B is the ForeignKey linked to "Id" column of Business table .

It would very helpful if we are able to execute both insert statement in
operation or transaction

Please guide.

With Regards,
Aditya


On Mon, Mar 12, 2018 at 11:37 AM, aditya shivankar <
shivankar.adit...@gmail.com> wrote:

> Respected sir,
>
> I created a dataservice with two queries defined for this purpose.
> but when i am trying to create a operation for this purpose, it is
> allowing me to enter only one query per operation.
>
> suppose i have two tables :
>
> 1. USER 2.BUSINESS
>
> I have a record like :
>
> <id>1</id>
> <PostAddress>11324</PostAddress>
> <Username>admin</Username>
> <name>John</name>
>
> this needs to be inserted in below tables like below and if any of the two
> insertion fails entry should not be done in other table as well and if done
> should be rolled back:
>
> 1. Business
> a. Id                 - 1
> b. PostAddress        - 11324
>
> where
> ID is the PrimaryKey
>
>
> 2. USER
>
> Columns :
> a. Username            - admin
> b. Name                - John
> c. Id_B                - 1
>
> where
> Username is the PrimaryKey
> Id_B is the ForeignKey linked to "" column of Business table
>
> Please Guide
>
> With Regards,
> Aditya
>
_______________________________________________
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

Reply via email to