Please help - updating DataSet with many to many constraints...

  • Thread starter Thread starter Sasha
  • Start date Start date
S

Sasha

Hi,

I have a typed dataset with a bunch of tables and many to many relations.
While updating I am having problems. That is the exception messages
"You cannot add or change a record because a related record is
required in table 'tblRoles'." But the related record DOES EXIST!
I even tried turning the constraints off while saving the dataset, the
exception still comes up ?!?!?!?


What can be wrong with this? Confuses the hell out of me...
Could anyone help?


Thank you!
 
Hi,

What is the backend database? If it is an Access database, please refer to
the following article:

ACC2000: "You Cannot Add or Change a Record..." Error Message When You Try
to Add a Product to a New Order
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q319320

If it isn't Access database, you can create a new typed dataset with few
tables from ground to see if the same problem occurs. It it works, it
indicates that there is a problem with the original dataset.

Sincerely,

Kevin
Microsoft Support

This posting is provided "AS IS" with no warranties, and confers no rights.
Get Secure! - www.microsoft.com/security

--------------------
| From: "Sasha" <[email protected]>
| Subject: Please help - updating DataSet with many to many constraints...
| Date: Thu, 11 Sep 2003 10:05:07 -0800
| Lines: 17
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <[email protected]>
| Newsgroups:
microsoft.public.dotnet.framework.adonet,microsoft.public.dotnet.languages.v
b.data
| NNTP-Posting-Host: filenet-gw.filenet.com 198.3.8.1
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP11.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.languages.vb.data:1847
microsoft.public.dotnet.framework.adonet:60882
| X-Tomcat-NG: microsoft.public.dotnet.framework.adonet
|
| Hi,
|
| I have a typed dataset with a bunch of tables and many to many relations.
| While updating I am having problems. That is the exception messages
| "You cannot add or change a record because a related record is
| required in table 'tblRoles'." But the related record DOES EXIST!
| I even tried turning the constraints off while saving the dataset, the
| exception still comes up ?!?!?!?
|
|
| What can be wrong with this? Confuses the hell out of me...
| Could anyone help?
|
|
| Thank you!
|
|
|
 
Back
Top