------------------------------------------------------------------------------------------
Split from SQL function LSql_Microsoft for v15.1.

Hello,

I think that now there is a version 3. Have a look at the fallowing link: https://support.industry.siemens.com/cs/document/109779336/connecting-an-s7-1500-to-an-sql-database?lc=en-ro

You can only call LSql_Microsoft once. Try to Enable the function, after connection is done, create/append the command string command in different parts of program and executeCommand (TRUE) when you want.
This procedure, with a PLC, is hard to manage. Also you are restricted to the string length (254 characters per command), and you have to transform values and dates to string in SQL format, append them and so on.

I see you are working with recipes so I guess you are using some kind of HMI. I recommend a VBscript ("ADODB.Connection") if you are using WinCC Advanced and run the script on tag event value change. Could be easier.

If you still need to use the PLC, I would have inserted a CASE event_id before LSql_Microsoft call and do there the string command and executeCommand. Just an idea:

CASE event_id OF:
0: //do nothing
LSql_Microsoft.executeCommand:= FALSE;

1: // event Start
LSql_Microsoft.command := "INSERT ......" ; //add your SQL command string
IF LSql_Microsoft.status == STATUS_NO_CALL AND NOT LSql_Microsoft.error THEN
LSql_Microsoft.executeCommand:= TRUE;
event_id:=0;
END_IF;

2:
.........;
END_CASE;