PC Review


Reply
Thread Tools Rate Thread

dataset.merge with itself-create multiple records with same values

 
 
=?Utf-8?B?Um9iaW4=?=
Guest
Posts: n/a
 
      17th Jun 2005
I am trying to create a dataset with multiple records that hold identical
data by merging a dataset with itself. I don't think this will work and I am
looking for other solutions.

For example, a dataset has a parent table called CATEGORY and a child table
called ITEMS. There is a foreign key column and the value is -1 for the
parent (and child refers to row -1). Now I want a dataset that has 3 records
with this same information. I want row -1, -2, and -3 all with the same
values. I don't think Merge is what I am looking for because when the dataset
tries to merge with itself, the primary key of -1 is the same and instead of
adding a new row with primary key -2 it merges (imagine that) which results
in still only one row. Does anyone have a better solution to this? Otherwise
I need to manually create all the tables and rows by looping through the
original dataset. Thanks.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge multiple records to word multiple tables =?Utf-8?B?aGVhZGx5?= Microsoft Access VBA Modules 1 22nd Sep 2007 11:45 PM
Merge Field Values from Different Records for Report with a Comma =?Utf-8?B?QmFyYmFyYSB0aGUgR0lTIEd1cnU=?= Microsoft Access Queries 1 12th Sep 2007 06:16 PM
How to merge multiple datarows within a single dataset =?Utf-8?B?UmF5bW9uZA==?= Microsoft ADO .NET 1 28th Sep 2005 08:44 PM
DataView does not show existing records after calling DataSet.Merge (ADO.NET 1.1 Bug?) Oleg Microsoft ADO .NET 1 17th Mar 2005 04:37 PM
Merge is adding 2 records to the dataset Hemang Shah Microsoft ADO .NET 5 23rd Feb 2005 10:04 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:00 AM.