Solved
Error while saving data
- Rookie
- 3 replies
I am getting data type conflict while saving data below is the query I got when I tried to debug
Best answer by Mark Jongeling
ChandanKavi wrote:
it is int only
The Software Factory might say it's an Int but sadly the database registered the column with the datatype Time(7). What you could do it either writing a query to Alter the datatype of the column to Int or do a Full upgrade. During the full upgrade, all tables will be recreated thus it will change the datatype to the datatype as entered in the Software Factory
This topic has been closed for comments
+23Hey ChandanKavi,
Can you share the data types of the table you are trying to update? This query is shown in the Debug screen right?
Let me know, maybe I can help 😉
Can you share the data types of the table you are trying to update? This query is shown in the Debug screen right?
Let me know, maybe I can help 😉
- Rookie
- 3 replies
Description nvarchar(20)
number_of_shelves int
presentation_color char(10)
number_of_shelves int
presentation_color char(10)
+23I think the column stand_type_id has the datatype 'time' and also think it is set to be an Identity column. The column will try and fill itself with a number, let say 1. But because the column is a Time column, it will give the "Msg 206, Level 16, State 2, Line 3 Operand type clash: int is incompatible with time" error.
Can you make sure the column stand_type_id is not 'Time'?
Reference:
Can you make sure the column stand_type_id is not 'Time'?
Reference:
- Rookie
- 3 replies
No mark stand_type_id is int
see number_of_shelves is what conflicting but I checked the data type it is int
see number_of_shelves is what conflicting but I checked the data type it is int
+23Then you found the problem there, 😉 number_of_shelves should indeed have the datatype Int
+23ChandanKavi wrote:
it is int only
The Software Factory might say it's an Int but sadly the database registered the column with the datatype Time(7). What you could do it either writing a query to Alter the datatype of the column to Int or do a Full upgrade. During the full upgrade, all tables will be recreated thus it will change the datatype to the datatype as entered in the Software Factory
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.