Our Brands

Impact-Company-Logo-English Black-01-177x54

Schneider Electric USA Website

Welcome to our website.
		
How can we help you today?
Example of structured text logic program to insert values into a data table

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

Schneider Electric USA

Explore more
Range:
Users group

Discuss this topic with experts

Visit our community and get advice from experts and peers on this topic and more
Explore more
Range:

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.

  • Products Documentation
  • Software Downloads
  • Product Selector
  • Product Substitution and Replacement
  • Help and Contact Center
  • Where to buy
  • Get a Quote
  • Find our Offices
  • Careers
  • Company Profile
  • Report a misconduct
  • Accessibility
  • Newsroom
  • Investors
  • EcoStruxure
  • Job Search
  • Blog
  • Tech Support: 877-342-5173
  • Privacy Policy
  • Cookie Notice
  • Terms of use
  • Change your cookie settings