Join us today!
Database Server Write DateandTime
Hello,
I am writing in MariaDB database similar to MySQL with TwinCAT and I define the string with:
TYPE ST_Register :
STRUCT
Id : DINT;
Name : STRING(30);
Age : INT;
Height : LREAL;
Glasses : STRING(6);
dt_DateAnd_Time : DT;
END_STRUCT
END_TYPE
VAR
stReg : ST_Register;
fbCommand : FB_FormatString;
sCommandAddReg : STRING(255);
END_VAR
fbCommand(
sFormat:= 'INSERT INTO `people` VALUES(%D,$'%S$',%D,%1.2F,%B,?????)',
arg1:= F_DINT(stReg.Id),
arg2:= F_STRING(stReg.Name),
arg3:= F_INT(stReg.Age),
arg4:= F_LREAL(stReg.Height),
arg5:= F_BYTE(stReg.Glasses),
arg6:= ????? (stReg.dt_DateAnd_Time), // date and time
sOut=> sCommandAddReg);
.- My question is I would like to add the date and time but I don't know how I have to add inside VALUES for the date and time format?
.- And my other question is that I don't have a Helper function like F_DT, for the FB_FormatString the input T_Arg, how could I put it?
Thanks you, 😀
https://github.com/runtimevic
https://github.com/TcMotion
https://www.youtube.com/playlist?list=PLEfi_hUmmSjFpfdJ6yw3B9yj7dWHYkHmQ
https://github.com/VisualPLC
Hello,
I answer to myself...
A possible solution would be to pass dateandtime to string format:
TYPE ST_Register :
STRUCT
Id : DINT;
Name : STRING(30);
Age : INT;
Height : LREAL;
Glasses : STRING(6);
dt_DateAnd_Time : DT;
END_STRUCT
END_TYPE
VAR
stReg : ST_Register;
fbCommand : FB_FormatString;
sCommandAddReg : STRING(255);
sDateAndTime : T_MaxString;
END_VAR
sDateAndTime := DELETE(DT_TO_STRING(dt_DateAnd_Time,3,1);
fbCommand(
sFormat:= 'INSERT INTO `people` VALUES(%D,$'%S$',%D,%1.2F,%B,$'%S$')',
arg1:= F_DINT(stReg.Id),
arg2:= F_STRING(stReg.Name),
arg3:= F_INT(stReg.Age),
arg4:= F_LREAL(stReg.Height),
arg5:= F_BYTE(stReg.Glasses),
arg6:= F_STRING(sDateAndTime), // date and time format string
sOut=> sCommandAddReg);
another more elegant and modern solution would be to use the Tc3_Database library instead of the Tc2_Database library,
with the Tc3_Database library we have improvements and among them we have the FB_PLCDBWriteEvt that has 3 methods,
one of them is WriteStruct, which will allow us to write a structure of data in the database,
I have also been testing FB_PLCDBCmdEvt and its Execute method with this I can write to the database but the fields in the database come out empty and I don't know why,
if someone can tell me how to solve it, I would be It's good that I mention it, so I also learn more things...
https://github.com/runtimevic
https://github.com/TcMotion
https://www.youtube.com/playlist?list=PLEfi_hUmmSjFpfdJ6yw3B9yj7dWHYkHmQ
https://github.com/VisualPLC
- 17 Forums
- 267 Topics
- 942 Posts
- 0 Online
- 722 Members