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

Post Reply
wlederer
Posts: 175
Joined: Fri Jan 27, 2012 4:20 am

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

Post 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?

wlederer
Posts: 175
Joined: Fri Jan 27, 2012 4:20 am

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

Post 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.

Post Reply