Hi,
Iu2019m using a matrix for a non-UDO user defined table. One of the fields in the table and in the matrix is an hour type field. When the user enters data to the field in the matrix, it shows a colon (i.e., 02:00 for 2 AM). When I try to save the value to the table using the DI API, it looks like the value is being saved to the table. But when I dismiss the form and bring it back up, it is evident that the hour data was not saved. SQL Server says the field is a small integer; but, when I try to save the value as an integer, I get an u201CIllegal value enteredu201D exception. When I try to save it as a date, an exception occurs because I canu2019t convert the u201C0200u201D string to a date. What do I have to do to the string u201C0200u201D to get the DI API to save it to the table as hour data?
Thanks,
Mike