Browse FAQs

Example of structured text logic program to insert values into a data table

Published date: 11 October 2018


DISCLAIMER 

This sample program is intended to demonstrate one or more programming functions or methods and is presented as programming example only. Schneider Electric assumes no liability for the use or application of this example program or any portion thereof.
 


This small logic program reads data from 3 database points named String, Point 1 and Point 2, and inserts this data into a custom table in ClearSCADA named CSTable1. 
 
PROGRAM InsertIntoTable
  VAR
    sWriteString AT %M(.String): STRING[250];
    sWriteValue1 AT %M(.Point 1): DINT;
    sWriteValue2 AT %M(.Point 2): DINT;
  END_VAR
 
  VAR NOCACHE
    vSQLWrite AT %D(INSERT INTO CSTable1 VALUES (?,?,?)) WITH_PARAMS sWriteString, sWriteValue1, sWriteValue2;
  END_VAR
 
  vSQLWrite.Execute();
 
END_PROGRAM

Was this helpful?

What can we do to improve the information ?

Can't find what you are looking for?

Reach out to our customer care team to receive information on technical support, assistance for complaints and more.