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