Failing to update/insert into column

mike55

mike55

Well-known member
Joined
Mar 26, 2004
Messages
726
Location
Ireland
Hi all,

My problem is as follows, I have a database table which contains multiple columns, one of these columns is called "Custom7". If I attempt to insert or update and row, the command will execute correctly and all the data, except "Custom7" will be inserted/updated.

I can understand why this column in particular is acting up, I have checked with the people that I work with, and they confirm that the stored procedures that I am using are correct. I have confirmed that the correct data is going into the stored procedure. I am not getting an error back from the stored procedure. And finally, the same code worked correctly in a SQL Server 2000, and works correctly on another persons machine.

Any suggestions on what is causing this error, or how I can solve it?

Mike55.
 
mike55 said:
Hi all,

My problem is as follows, I have a database table which contains multiple columns, one of these columns is called "Custom7". If I attempt to insert or update and row, the command will execute correctly and all the data, except "Custom7" will be inserted/updated.

I can understand why this column in particular is acting up, I have checked with the people that I work with, and they confirm that the stored procedures that I am using are correct. I have confirmed that the correct data is going into the stored procedure. I am not getting an error back from the stored procedure. And finally, the same code worked correctly in a SQL Server 2000, and works correctly on another persons machine.

Any suggestions on what is causing this error, or how I can solve it?

Mike55.
Click to expand...

What type of the "Custom7" column ?
Do you have any triggers on the table youre working on ?
Ive mentined that your code works correctly on another machine, is that machine uses the same SQL Server ? Does that machine have the same "
"regional and language" settings?
 
Back
Top