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


Sorry, I must have misunderstood you. Are you saying you want to be able to
select from three tables and send the results back to BizTalk? Can you post
your query here or elaborate more on what you are trying to accomplish?

Thiago Almeida
http://www.connectedthoughts.wordpress.com

"babu" wrote:

also I dont have at-identity . with out that how can we populate the data

"Babu" wrote:

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: Query vs form with child & parent: Deleting rows
    ... subordinate to that record, that is, all individuals (and sometimes child ... companies) whose Owner field contains the record key of the parent company. ... That second form is fed by this query: ... But I have a child table called "Channel"; ...
    (microsoft.public.access.forms)
  • Re: Queries involving subforms
    ... If you create your query, with the parent & child tables joined, and add the ... you will get as many as there are child rows ...
    (microsoft.public.access.queries)
  • Query vs form with child & parent: Deleting rows
    ... When I delete a row from a query involving both parent and child rows, ... when I display this query in a form and delete a row from there, ...
    (microsoft.public.access.forms)
  • Re: list box from query
    ... If this helps, I have three nested forms (say, the parent, ... and grandchild) The listbox is in the grandchild ... and is based on a value in the child form. ... me to enter the query value. ...
    (microsoft.public.access.formscoding)
  • Unix Programming FAQ (v1.37)
    ... Why use _exit rather than exit in the child branch of a fork? ... Why doesn't my process get SIGHUP when its parent dies? ... How do I create a named pipe? ... How do I compare strings using regular expressions? ...
    (comp.unix.programmer)