Best answer by Mark Jongeling
View original
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
This topic has been closed for comments
Userlevel 7
+23
Userlevel 7
+23
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
Userlevel 7
+23
Then you found the problem there, 😉 number_of_shelves should indeed have the datatype Int
- Rookie
- 3 replies
-
9 August 2019
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
Userlevel 7
+23
I 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
-
9 August 2019
Description nvarchar(20)
number_of_shelves int
presentation_color char(10)
number_of_shelves int
presentation_color char(10)
Userlevel 7
+23
Hey 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 😉
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.