Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > Biztalk
|
Biztalk General discussion about Biztalk server.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Biztalk section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 17th, 2006, 09:31 AM
Registered User
 
Join Date: Jul 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to janamca_thanan Send a message via Yahoo to janamca_thanan
Default Problem in geting the @@Identity Value

Hi to all,

I am using Updategram.I have a problem to get the IDENTITY.
I have follwed the following link.
http://msdn.microsoft.com/library/de...68ff245df1.asp
its working fine only single parent and its related child records.


I explain my problem with an example as below:

I have two tables in sql, one is master another one is detail. these are
related to one another. let us assume, one is studentname table another one
is studnetmark detail. I have added the data into these table with
sqladapter.First i have inserted into studentname in one table and take the
IDENTITY, after that insert into student Mark table with StudentName
Identity. I have inserted the StudentName s and respective Marks in
StudentMark details. But i can't get the Correct IDENTITY. But Last IDENTITY
has been repeated for all the StudentMark's rows which ever i inserted.

This is My Inbound Message:

<ns0:Student xmlns:ns0="http://InsertMarklist.Input">
  <Details Name="jana" City="VLR">
    <Mark EName="EName_0" M1="50" M2="50" M3="50" />
    <Mark EName="EName_1" M1="50" M2="50" M3="50" />
  </Details>
  <Details Name="sample" City="City_1">
    <Mark EName="EName_4" M1="50" M2="50" M3="50" />
    <Mark EName="EName_5" M1="50" M2="50" M3="50" />
  </Details>

</ns0:Student>



BUT I GOT AS FOLLOWS

STUDENTNAME Table
-------------------------

ID NAME CITY
-------------------------------
22 jana VLR
23 sample City_1

STUDENTMARK Table (Here i m having problem in ID)
-------------------------

ID EXAM M1 M2 M3 TOT
----------------------------------------------------------------------
23 EName_0 50 50 50 150
23 EName_1 50 50 50 150
23 EName_4 50 50 50 150
23 EName_5 50 50 50 150

NOTE: SEE the ID column is in same value.

I expected in SQL

STUDENTNAME Table
-------------------------

ID NAME CITY
-------------------------------
22 jana VLR
23 sample City_1

STUDENTMARK Table
-------------------------

ID EXAM M1 M2 M3 TOT
----------------------------------------------------------------------
22 EName_0 50 50 50 150
22 EName_1 50 50 50 150
23 EName_4 50 50 50 150
23 EName_5 50 50 50 150

Thanks In Advance
Jana


Jana





Similar Threads
Thread Thread Starter Forum Replies Last Post
geting the value from an Object JAdkins Classic ASP Basics 1 June 29th, 2007 10:59 AM
Geting table information from a control toddw607 Access 2 March 1st, 2007 08:24 AM
@@IDENTITY Problem datagram Pro VB.NET 2002/2003 2 May 19th, 2005 01:34 PM
Geting Index of a children tutul128 XML 2 May 27th, 2004 10:34 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.