RE: Generating Schemas from one parent table and 2 child table

Tech-Archive recommends: Fix windows errors by optimizing your registry

yes I am talking about sql adapter. The scenario is that I have a parent
table with 2 child table. I need to generate schema using ADD GENERATED
WIZARD in Biztalk.let me know if any other info required I can provide

"Thiago" wrote:


Hi, are you talking about the SQL Adapter with updategrams? You need to use
at-identity to copy the parent id to the child/children. Have a look at the
"Insert New Order" section of this page:
http://technet.microsoft.com/en-us/library/ms935658.aspx
Or here for another example:
http://blogs.msdn.com/skaufman/archive/2005/01/31/363920.aspx

These examples have only one child table but you can repeat it for two if
the parent is the same, let us know how it goes.
Also, if you weren't talking about the SQL Adapter with updategram please
give us a bit more info.

Thiago Almeida
http://connectedthoughts.wordpress.com

"babu.dhinakar@xxxxxxxxx" wrote:

I am trying to generate schemas using ADD generated items wizard. I
need a query to generate a schema which contains one parent and 2
child from 3 different table. They have PK and GK relation between
them. I tried writing query using joins and was not successfull.

.

Relevant Pages

  • Re: daMyDatatable.Update fails for linked dataset tables (using Ol
    ... Schema to None and now it works as it should. ... >> 1/ Add Parent record to Parent DataTable ... >> 2/ Add Associated Child Record to Child DataTable ... > set Accept/Reject Rule to Cascade, if you have then set it to None instead. ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Generating Schemas from one parent table and 2 child table
    ... that I need to generate a schema using BTS Schema generation wizard. ... table with 2 child table. ... are you talking about the SQL Adapter with updategrams? ... at-identity to copy the parent id to the child/children. ...
    (microsoft.public.biztalk.general)
  • RE: Schema: Relationship expected on Error
    ... I looked at your schema and I wanted to clarify one thing first:the child ... every child element that is mapped to a different table than the parent. ... > XML) to be informative in helping me with XML. ... > error 'Schema: relationship expected on 'PSECP200'' when executing my script. ...
    (microsoft.public.sqlserver.xml)
  • RE: SQLXMLBulkLoad - relationship error
    ... You have to use sql:datatype annotation like this: ... When I comment this relationship out of the schema, ... The parent table is created and loads correctly. ... From the child table: ...
    (microsoft.public.sqlserver.xml)
  • RE: Generating Schemas from one parent table and 2 child table
    ... table with 2 child table. ... I need to generate schema using ADD GENERATED ... at-identity to copy the parent id to the child/children. ...
    (microsoft.public.biztalk.general)