Discover our Clipsal Smart Home packages as seen on The Block 2018

in location

OR

I'm looking for

  • Wholesalers
    • Uncheck All Check All
  • EXPERTISE
    • Expand
    • Expand
    • Expand
    • Uncheck All Check All
  • Switchboard Manufacturers
    • Uncheck All Check All
OR

The best way to see what Clipsal electric products can do for your home is seeing them in action at a Clipsal Display Centre.

Product stock may vary according to location. If you're after a specific product range, please check with your chosen location before visiting.

10 Results
    Load More Load Complete
    Change Location

    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

    Didn’t find what you were looking for?

    Try Searching Again View Our Categories

    Need further assistance?

    Our Customer Care department provides total customer service solutions for our residential, industrial and commercial applications.

    Get Assistance