I downloaded a sqlite file from the one that generates the trend register, it gives me the time in TS and the value, but I do not know in what format it is returned because a value of 210 gives me a record of 1131986942 in the value field.
best regards,
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
doing tests I have verified that the problem is with the real values since the database in sqlite is built with all the variables in type INT. Someone can help me that the database has the types corresponding to its variables or how to pass the value that gives you from a real variable the database to the real data.
Thank you very much, it would be very helpful ...
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
jbarrio hat geschrieben:
hello:
doing tests I have verified that the problem is with the real values since the database in sqlite is built with all the variables in type INT. Someone can help me that the database has the types corresponding to its variables or how to pass the value that gives you from a real variable the database to the real data.
Thank you very much, it would be very helpful ...
None?
Enviado desde mi Plus E mediante Tapatalk
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
no clue what you are doning, this should simply work
with out any probems.
You need to give more Details or your project otherwise hard to try to help.
BR
Edwin
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
hi:
Sorry for not explaining myself well, my English is not good.
I make a simple application with three variables with the same value (value=10) INT, REAL, LREAL in the visualization it looks perfect all read perfect.
Now download /var/opt/codesys/Plcprogram/trend/Application.Test.sqlite ( the trend record is called Test).
open this archive with mozilla firefox sqlite manager.
The variable INT is record perfect, the records is 10
The variable REAL, the records is 1092616192
the variable LREAL, the records is 4621819117588972000
my problem is that I do not know how to do this conversion and I need to save values with decimals.
If something does not explain me well, tell me
thank you very much for taking your time.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
very grateful for your help, now I can from codes and move from one to another.
Do you know of any place where you can find documentation on how to make these calculations codesys to be able to do them in an excel sheet?
very very thanks
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I downloaded a sqlite file from the one that generates the trend register, it gives me the time in TS and the value, but I do not know in what format it is returned because a value of 210 gives me a record of 1131986942 in the value field.
best regards,
hello:
doing tests I have verified that the problem is with the real values since the database in sqlite is built with all the variables in type INT. Someone can help me that the database has the types corresponding to its variables or how to pass the value that gives you from a real variable the database to the real data.
Thank you very much, it would be very helpful ...
Enviado desde mi Plus E mediante Tapatalk
Hi,
no clue what you are doning, this should simply work
with out any probems.
You need to give more Details or your project otherwise hard to try to help.
BR
Edwin
hi:
Sorry for not explaining myself well, my English is not good.
I make a simple application with three variables with the same value (value=10) INT, REAL, LREAL in the visualization it looks perfect all read perfect.
Now download /var/opt/codesys/Plcprogram/trend/Application.Test.sqlite ( the trend record is called Test).
open this archive with mozilla firefox sqlite manager.
The variable INT is record perfect, the records is 10
The variable REAL, the records is 1092616192
the variable LREAL, the records is 4621819117588972000
my problem is that I do not know how to do this conversion and I need to save values with decimals.
If something does not explain me well, tell me
thank you very much for taking your time.
If your real value (a) is strored in an int (intVal). Do:
B:pointer to real;
B:=adr(intVal)
A:=B^
very thanks !!!!!!!!!!!!!!!!
very grateful for your help, now I can from codes and move from one to another.
Do you know of any place where you can find documentation on how to make these calculations codesys to be able to do them in an excel sheet?
very very thanks
There is'nt any calculation. We only have told the compiler that the 64 bits are a real number representation.
You can do the same using a union with an integer and one real.