Hello Guys,

I Have finished the Siemens Sample Project about ''Connecting a S7-1200 PLC / S7-1500 PLC to a SQL Database'' and everything is working fine in terms of connection and sending/receiving data.

What I am working on now ,is to scan a barcode and receive this information in database. I have an unique identifier column I created recently (assuming this is the scanned code), and I kept all the other columns from the Siemens sample ( Amount , Colour, Fruit...).

What I want to do is Every time I scan the barcode , the unique identifier column will receive this information and update the other columns and send this to the PLC . So , without forcing to insert this value to the PLC  I want to do it automatically and send these data and the same from PLC.

I am assuming I need to write a SQL query to do this and write a new logic in the Analyse Tokens block? Do you guys have any idea about this?

Thanks In Advance

------------------------------------------------------------------------------------------
Split from S7-1200 & SQL Tags Identificaiton.

in the Static/Cmnds array put your SQL select statement. 'Select Column1,Column2 from TableName where Barcode = $'' Then add in the barcode data. '$';' to close.

Pass that as the command to the FB and raise execute command.

I just read your previous thread and I think I know what your missing.  I opened a project I have done this on and will try show you how I did it:

Cmnds[3] := 'UPDATE [dbo].[UDInformation] SET [Printed] = 1 WHERE [PDID] = $'';
CmdIndx := 3;

#Cmnd := #Cmnds[#CmdIndx];
IF #CmdIndx = 3 THEN
   #Cmnd := CONCAT(IN1 := #Cmnd, IN2 := "Report_DB".PdId,
   IN3 := '$';');
END_IF;

The CONCAT function adds the (Update SQL command string) + (The value) + (the ending hyphen and semi colon) to make the SQL command

Update [dbo].[UDInformation] SET [Printed] = 1 WHERE [PDID] = '1234-567-ABCD'

Hello,

Thank you for your reply ! Is this something to write in the command block , cmnd[3] PLC?

Thanks,