Page 1 of 1

How to insert values to the "Time" column of Data Logger

Posted: Thu Jul 05, 2018 4:03 am
by wlederer
My task is to move a Data Logger from internal HMI memory (X2Pro) to USB or SD. I made backup of existing database on USB and wrote a script to make records. It works, but there is a problem with the field "Time". It has format DateTime.
How to insert a value into this column?

Re: How to insert values to the "Time" column of Data Logger

Posted: Wed Jul 18, 2018 2:40 am
by wlederer
I found solution. After backing up the internal database to USB memory, it was opened with SQLite Expert and the field "Time" type was changed from datetime to nvarchar.
But, how to insert data to fields with SQL type "datetime" is not yet clear.