Table SQL Server | Custom Web Control | WinCC Unified & V8

Custom Web Control

About Table SQL Server

Table SQL Server is a powerful Custom Web Control designed for industrial SCADA and HMI applications, providing a robust interface for direct SQL database interaction. It offers a comprehensive data management solution for SQL records, featuring a high-performance searchable table with integrated CRUD (Create, Read, Update, Delete) operations. This control bridges the gap between your relational databases and your WinCC Unified or WinCC V8 environment, enabling operators to view and manage data without leaving the HMI screen.

Key Features

• Full Database Interaction: Perform data manipulation directly from the HMI using configurable SQL query templates for sqlInsertQuery, sqlUpdateQuery, and sqlDeleteQuery.
• Flexible Connectivity: Connect via dbConnectionString or individual parameters like dbServer, dbDatabase, dbUser, and dbPassword.
• Event-Driven Architecture: Seamlessly trigger WinCC scripts using built-in events such as RowSelected, AddRequested, EditRequested, DeleteRequested, and RefreshRequested.
• Dynamic UI Feedback: Real-time status communication with connectionStatusText and noSelectionText to guide operators during data entry.

  Customization

  With 21 adjustable properties, this control is fully customizable. Engineers can toggle visibility for action buttons using showAddButton, showEditButton, and showDeleteButton. SQL integration is simplified through the sqlSelectQuery and primaryKeyColumn properties, while the visual appearance is managed via backgroundColor and button labels like addLabel, editLabel, and deleteLabel.

  Use Cases

  Perfect for recipe management, batch logging, maintenance tracking, and any scenario requiring a direct interface with SQL Server records on the factory floor. It allows for advanced data filtering using the searchPlaceholder functionality.

  Compatibility

  Works with WinCC Unified (TIA Portal) and WinCC V8. Provides built-in methods like setTableData, setConnectionStatus, and clearSelection for dynamic runtime updates and script-based control.

  💡 TIA Portal Reminder: Remember to uncheck the "Read only" option in TIA Portal when linking a tag to a property that needs to be written from the Custom Web Control. If you do not, the CWC will only be able to read the HMI tags and not write to them.

  ⚠️ AI-Generated: This custom web control was automatically generated using AI. Please test and validate before deploying in production environments.

  ⚠️ AI-Generated: This custom web control was automatically generated using AI technology. It may contain errors or unexpected behavior. Users are responsible for testing and validating before using in production environments.