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?
How to insert values to the "Time" column of Data Logger
Re: How to insert values to the "Time" column of Data Logger
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.
But, how to insert data to fields with SQL type "datetime" is not yet clear.