The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
"Update DB failed"
Johannes_N
Member Posts: 1 
Learner III
Hey guys,
i´m trying to use "Update Database" with an MS SQL Server 2012. I´m updating only one column. But RM tried to touch the hole row and throws an exception.
Exception: Database error occurred: Cannot insert the value NULL into column'Text, Table 'TableName'; column does not alles null. Insert fails.
But I tried an update funktion and not on this columns which a not allow NULL. What did go wrong?
Thanks for you help.
Best wishes
Johannes
i´m trying to use "Update Database" with an MS SQL Server 2012. I´m updating only one column. But RM tried to touch the hole row and throws an exception.
Exception: Database error occurred: Cannot insert the value NULL into column'Text, Table 'TableName'; column does not alles null. Insert fails.
But I tried an update funktion and not on this columns which a not allow NULL. What did go wrong?
Thanks for you help.
Best wishes
Johannes
Tagged:
0
Answers
I'm not 100% sure what the problem is, but the "Update Database" operator works the following: You have an example set with exactly the same columns as your database table. Then you select one or more ID columns via the "attribute filter" parameters. These are the columns (and values) which will form the WHERE clause in the UPDATE statement. ALL other columns are then used for the SET clause. If the WHERE clause returns 0 rows, the UPDATE statement will be changed to an INSERT.
Regards,
Marco