Error source net sqlclient data provider

1. Dec 20th, 2012, 06:35 AM

   
   

   #1

   [RESOLVED] No row was updated. The data in row 1 was not committed.
   

   Hi,

   I am trying to manually edit a database in Visual Studios 2010! However, when I try to insert data into the table I receive the following error:

   No row was updated.
   The data in row 1 was not committed.
   Error Source: .Net SqlClient Data Provider.
   Error Message: String or Binary data would be truncated.
   The statement has been terminated.

   I have encountered this error a while ago but I have forgotten how I solved it.

   Thanks,

   Nightwalker

   when you quote a post could you please do it via the «Reply With Quote» button or if it multiple post click the «»+» button then «Reply With Quote» button.
   If this thread is finished with please mark it «Resolved» by selecting «Mark thread resolved» from the «Thread tools» drop-down menu.
   https://get.cryptobrowser.site/30/4111672

   ---

2. Dec 20th, 2012, 07:24 AM

   
   

   #2

   Re: No row was updated. The data in row 1 was not committed.
   

   String or Binary data would be truncated.
   That typically means you’re trying to enter more data into a field that it can accept, e.g. 51 characters in to a varchar(50) field.

   The best argument against democracy is a five minute conversation with the average voter — Winston Churchill

   Hadoop actually sounds more like the way they greet each other in Yorkshire — Inferrd

   ---

3. Dec 20th, 2012, 07:09 PM

   
   

   #3

   Re: No row was updated. The data in row 1 was not committed.
   

   Ah ok! Looking at a project that is alost identical but works the definition for the particular field which is causing problem is «nvarchar(1024)» however, in this table that particular field is set to «nvarchar(10)» definitely not big enough. However, if I try to make the change I receive the following error:

   You cannot save changes that would result in one or more tables being re-created. You can override this behavior by changing your configuration options. Open the Tools menu, click Options. In the Options dialog box, expand the Database Tools node and click Table and Database Designers. You can clear the «Prevent saving changes that require table re-creation» then retry the save operation. The save might take a long time because the data in the tables must be copied to temporary tables.

   Will try this and report back.

   Edit:

   Damn, there are only four node under Options, Environment, Projects and Solutions, Text Editor and Windows Forms Designer.

   Last edited by Nightwalker83; Dec 20th, 2012 at 07:14 PM.

   Reason: Adding more!

   when you quote a post could you please do it via the «Reply With Quote» button or if it multiple post click the «»+» button then «Reply With Quote» button.
   If this thread is finished with please mark it «Resolved» by selecting «Mark thread resolved» from the «Thread tools» drop-down menu.
   https://get.cryptobrowser.site/30/4111672

   ---

4. Dec 21st, 2012, 05:00 AM

   
   

   #4

   Re: No row was updated. The data in row 1 was not committed.
   

   Are you looking in Management Studio? My Options dialog has a Designers node and I found the flag quite easily under there. If you can’t find the option you can always carry out the steps yourself manually. Copy all the data sideways into a new table, drop the existing table and recreate it exactly as it was before but with the one column redefined. Don’t forget that the table is more than just the data it contains, you want to make sure you recreate all the same indexes, triggers, constraints etc so make absolutely sure you know exactly what’s there before you do anything. Scripting the various elements for create will do alot of the work for you.

   Be cautioned, though, that this isn’t something you should be doing lightly. What that message is telling you is that, in order to make that change, the DBMS (or you) is going to have to completely delete and recreate that table. If you get some catastrophic problem half way through that process you could get left in a right mess. So before you do anything TAKE A FULL BACKUP.

   The best argument against democracy is a five minute conversation with the average voter — Winston Churchill

   Hadoop actually sounds more like the way they greet each other in Yorkshire — Inferrd

   ---

5. Dec 21st, 2012, 06:48 AM

   
   

   #5

   Re: No row was updated. The data in row 1 was not committed.
   

   Management Studio? I am referring to the Tools, Options menu in Visual Studios.

   Edit:

   Forgot to uncheck the «Show all settings» check box! After that I was able to located the setting I was looking for under the «Table and Database Designers» node and «Table and Diagram Option». Unchecking the «Prevent saving changes that require table re-creation» check box and clicking «OK» solved the problem.

   Last edited by Nightwalker83; Dec 21st, 2012 at 07:13 AM.

   Reason: Fixed spelling!

   when you quote a post could you please do it via the «Reply With Quote» button or if it multiple post click the «»+» button then «Reply With Quote» button.
   If this thread is finished with please mark it «Resolved» by selecting «Mark thread resolved» from the «Thread tools» drop-down menu.
   https://get.cryptobrowser.site/30/4111672

   ---

6. Nov 12th, 2013, 02:14 AM

   
   

   #6

   

   
   Frenzied Member
   

   

   ---

   Re: [RESOLVED] No row was updated. The data in row 1 was not committed.
   

   I’m getting this SQL Server error when I go to update a «text» field which only has a couple of hundred characters in it. How can this be? Can I safely just update the field type to «varchar(max)» without losing any data from that field?

   ---

7. Nov 21st, 2013, 08:46 PM

   
   

   #7

   Re: [RESOLVED] No row was updated. The data in row 1 was not committed.
   

   Originally Posted by robertx
   

   I’m getting this SQL Server error when I go to update a «text» field which only has a couple of hundred characters in it. How can this be? Can I safely just update the field type to «varchar(max)» without losing any data from that field?

   You are better off starting your own thread the cause and solution to your problem is different from mine.

   when you quote a post could you please do it via the «Reply With Quote» button or if it multiple post click the «»+» button then «Reply With Quote» button.
   If this thread is finished with please mark it «Resolved» by selecting «Mark thread resolved» from the «Thread tools» drop-down menu.
   https://get.cryptobrowser.site/30/4111672

   ---

Просто создала мою базу данных, но когда я вставляю некоторые строки с редактирующим интерфейсом, я получаю эту ошибку:

No row was updated.
The data in row 2 was not committed.
Error Source : .Net SqlClient Data Provider.
Error Message: The INSERT statement conflicted with the FOREIGK KEY constraint "FK_Utilisateur_Droit". The conflict occured in database "NewNDA", table "dbo.Droit", column 'idDroit'.
The satement has been terminated.

Моя таблица Droit состоит из:

idDroit (PK, int, not null)
DRT_libelle (varchar(50), not null)
DRT_visualisation (bit, not null)
DRT_modification (bit, not null)
DRT_suppression (bit, not null)

И моя таблица Utilisateur:

idUtilisateur (PK, FK, int, not null)
USR_Nom (varchar(50), not null)
USR_Prenom (varchar(50), not null)
USR_Fonction (varchar(50), not null)
idDroit (int, not null)
idEntreprise (int, not null)

У вас есть идеи по поводу моей проблемы? Благодарю!

Изменение: Моя инструкция insert:

INSERT INTO Utilisateur(USR_Fonction, USR_Nom, USR_Prenom, idDroit, idEntreprise)
VALUES ('Test', 'Nom', 'Prenom', '2', '2')

Возвращено:

Msg 547, Level 16, State 0, Line 1
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Utilisateur_Droit". The conflict occurred in database "NewNDA", table "dbo.Droit", column 'idDroit'.
The statement has been terminated.

Сценарий Утилизатора:

CREATE TABLE [dbo].[Utilisateur](
[idUtilisateur] [int] IDENTITY(1,1) NOT NULL,
[USR_Nom] [varchar](50) NOT NULL,
[USR_Prenom] [varchar](50) NOT NULL,
[USR_Fonction] [varchar](50) NOT NULL,
[idDroit] [int] NOT NULL,
[idEntreprise] [int] NOT NULL,
CONSTRAINT [PK_Utilisateur] PRIMARY KEY CLUSTERED
(
[idUtilisateur] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

Сценарий Дроита:

CREATE TABLE [dbo].[Droit](
[idDroit] [int] IDENTITY(1,1) NOT NULL,
[DRT_libelle] [varchar](50) NOT NULL,
[DRT_visualisation] [bit] NOT NULL,
[DRT_modification] [bit] NOT NULL,
[DRT_suppression] [bit] NOT NULL,
CONSTRAINT [PK_Droit] PRIMARY KEY CLUSTERED
(
[idDroit] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

Join Tek-Tips^® Today!

Join your peers on the Internet’s largest technical computer professional community.
It’s easy to join and it’s free.

Here’s Why Members Love Tek-Tips Forums:

• Talk To Other Members
• Notification Of Responses To Questions
• Favorite Forums One Click Access
• Keyword Search Of All Posts, And More…

Register now while it’s still free!

Already a member? Close this window and log in.

Join Us             Close