No announcements
Found 2755225 threads
-
0 VotesParent child data insert and update issue
Hi Mou_inn, Based on your description, I create a demo and reproduce your issue on side, please modify your code like this: // selecting addressAnswered | 2 Replies | 299 Views | Created by Sudip_inn - Thursday, November 3, 2016 2:42 PM | Last reply by Sudip_inn - Friday, November 4, 2016 1:31 PM
-
0 Votes
Insert data to Parent and Child table
IDENT_CURRENT as soon as you insert the value in to the Parent Table and use the same to insert the values in to the Child Table.Answered | 10 Replies | 20544 Views | Created by SQL Insane - Wednesday, August 15, 2012 2:14 AM | Last reply by shriprasanna - Thursday, August 16, 2012 12:53 PM -
0 Votes
can't save parent/child entries
dataset. To prevent data integrity errors from being raised, the best practice is to update the database in the following sequence: 1. Child table: ...Answered | 2 Replies | 3355 Views | Created by Grecko - Monday, April 27, 2009 9:28 AM | Last reply by Grecko - Wednesday, June 24, 2009 3:18 AM -
0 Votes
Concurrency Issue - More than one entity in changeset (SL4B, WCF RIA, EF4, VS2010B)
different type (one from a datagrid, the other the parent of the entity [by FK] on the main control surface), the datagrid one has a concurrency error (child) and the ... -
0 Votes
Parent/Child Insert Order
As VMazur pointed out in another thread, this article on how to Update Parent-Child Data with an Identity Column may helpUnanswered | 1 Replies | 5002 Views | Created by Devin S Howe - Friday, October 24, 2008 9:42 PM | Last reply by Mark.Ashton - MSFT - Wednesday, October 29, 2008 4:05 PM -
0 Votes
How to update parent table identity column values in child table
Now we have reinserted all the data into parent table and identity values are now in sequence. But we have child table with huge records with old ...Answered | 6 Replies | 1156 Views | Created by Das Bavan - Wednesday, March 4, 2020 9:18 AM | Last reply by Erland Sommarskog - Wednesday, March 4, 2020 10:40 PM -
0 Votes
another Parent child data insert question
/child data. so, if my new parent ids are (4,5,6) how do I do a mapping and insert the corresponding child data ? ProwID 1 gets ...Answered | 2 Replies | 1291 Views | Created by Ranga1 - Tuesday, April 30, 2013 3:00 PM | Last reply by Ranga1 - Tuesday, April 30, 2013 6:28 PM -
0 Votes
Insert Parent Child records...
src_orders in the source database. We have a parent Order table and a child OrderDetails table in the target database. We need to pick one row from src_orders ...Answered | 2 Replies | 8079 Views | Created by Satyajit - Friday, April 28, 2006 5:51 AM | Last reply by grantdi - Friday, April 28, 2006 5:23 PM -
0 Votes
parent and child entities update
if I modified remarks properties for both parent and child entities at the same time. I can only update the parent entity when I click the save ...Answered | 5 Replies | 10772 Views | Created by 886699 - Saturday, January 16, 2010 2:13 AM | Last reply by 886699 - Monday, January 18, 2010 9:13 AM -
0 Votes
Parent child update
child record detail (no grid) the child table does not update. I did set cascade rule, fk constraint. I did set the datasource of the child to the data ...Unanswered | 1 Replies | 3221 Views | Created by Dana7 - Tuesday, June 19, 2007 4:24 PM | Last reply by Feng Chen - Friday, June 22, 2007 7:42 AM -
0 Votes
Parent and Child Data files
is because the code call this SetPrimaryKey sub within both the parent TableAdapter and child TableAdapter(WinePruchaseTableAdapter and ...Answered | 6 Replies | 3414 Views | Created by IrishWolf - Thursday, June 10, 2010 7:50 PM | Last reply by IrishWolf - Thursday, June 24, 2010 9:37 PM -
0 Votes
Wizard Style Parent Child Insert.
create the child as an entity by adding it to the parent entity not setting the parent id of the new child. Does that make ...Answered | 5 Replies | 1934 Views | Created by w.darnellg.g - Thursday, December 22, 2011 5:20 PM | Last reply by w.darnellg.g - Tuesday, January 3, 2012 3:31 PM -
0 Votes
Parent child hierarchy issue
Please ignore this as I have found the soultion. In the case of Parent- child hierarchy we need to give the name column in the child Key column. for ...Answered | 1 Replies | 5160 Views | Created by Gaurav 17 - Wednesday, June 1, 2011 6:09 AM | Last reply by Gaurav 17 - Wednesday, June 1, 2011 6:52 AM -
0 Votes
Insert data Flatfile table to Parent and child tables
Hi All, I have Flatfile table which is we getting from daily txt files and i want to populate flatfile data to parent as well as ...Unanswered | 2 Replies | 793 Views | Created by RajVasu - Friday, March 20, 2015 5:03 AM | Last reply by HoroChan - Tuesday, March 24, 2015 1:05 PM -
0 Votes
Insert data in parent and child table (one row in parent table and multiple rows in child table)
You can use Stored Procedure to insert data into Child and Parent tables. you can get identity value of last inserted row using @@identity immediately ...Answered | 5 Replies | 16097 Views | Created by adilahmed - Saturday, November 10, 2012 12:07 PM | Last reply by Ahsan Kabir - Saturday, November 10, 2012 6:54 PM -
0 Votes
Parent-Child variable issue
(child.dtsx). In the parent package, I have a variable named var1 (data type String) with value=test In my child package, I having a script task using the ...Unanswered | 6 Replies | 4038 Views | Created by agrapa_n - Wednesday, April 23, 2008 3:32 PM | Last reply by DoolinDalton - Wednesday, April 23, 2008 6:52 PM -
0 Votes
problem in update child table in vb.net
, update, and delete recored; 3. Child table: insert and update record. Here is some information about ...Answered | 3 Replies | 2623 Views | Created by haqayyum - Wednesday, June 6, 2012 9:10 AM | Last reply by Mark Liu-lxf - Friday, June 15, 2012 8:01 AM -
0 Votes
Issue with Parent child hierarchy
Hi Team, I have defined a parent child hierarchy data in the table is shown below: empsk, empid, empname, mgrid, ...Answered | 1 Replies | 2746 Views | Created by Eswararao C - Thursday, May 10, 2012 12:21 PM | Last reply by Eswararao C - Thursday, May 10, 2012 12:25 PM -
0 Votes
Inserting data in parent and child tables with many child record for every parent record
I have been having a problem trying to insert data in parent and child tables from CheckedListBox items.The parent table has the parentID ... -
0 Votes
How to perform hierarchical updates with identity PK columns on both parent and child tables? SQLCE
errors from being raised, the best practice is to update the database in the following sequence: 1. Child table: delete records. 2. Parent ...Answered | 3 Replies | 2545 Views | Created by Naomarik - Wednesday, April 16, 2008 4:22 PM | Last reply by Riquel_Dong - Monday, April 21, 2008 8:03 AM - Items 1 to 20 of 2755225 Next ›
No announcements
