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
Released for: Schneider Electric USA


Need help?
Product Selector
Quickly and easily find the right products and accessories for your applications.
Get a Quote
Start your sales inquiry online and an expert will connect with you.
Where to buy?
Easily find the nearest Schneider Electric distributor in your location.
Help Center
Find support resources for all your needs, in one place.