SCADA/HMI/MES/PLC/Database/Reporting Developer Resource


presys	\|	scadadev.com

Hardware

HMI/SCADA

MES

Database

Device Integration

Reporting

Database

Microsoft SQL Server

Historian

Oracle

Connectivity

SQL

Developer Resource

Most Popular

Welcome to scadadev.com, the SCADA systems developer resource. Here you will find advice and guidance for HMI and MES development, including resources for PLCs, databases, reporting and lots more.

1. SCADA: Logging Tag Values with InTouch

2. ASP.NET Report Viewer Control Issues

3. Creating an ODBC Data Source Connection

4. SCADA: InTouch HMI - Deleting Unused Tags

5. Using SQL to Create a Database Table

6. Using SQL to Delete a Database Table

7. Using SQL to remove all the Data from a Database Table

8. SCADA: Starting a Windows Application from InTouch

9. SCADA: InTouch HMI - Printing Windows

10. SCADA: Checking if a Windows Application is open using InTouch

11. Using SQL to Insert a Row into a Database Table

12. SCADA: InTouch – Converting Windows to a Different Resolution without Resizing the Text, Symbols, etc

Sponsors

Page 1 of 2

Previous Next

Creating an SQL Server database from a backup file
If you've ever created a backup of an SQL Server database you may have experienced difficulties in restoring or deploying the backup to another server. In many cases the backup will need to be used as a way of deployment to a different server, but this causes an issue if the original database isnt already attached to the target server. A database can be created from a backup file using a simple SQL query. Within Microsoft SQL Server Management Studio (2005 or 2008), login to the target ser...
	Published 11 March 2009	Author scadadev.com	Views 1689

Creating an ODBC Data Source Connection
While there are many ways of creating data connections for use in software development and applications, one of the most commonly used and supported methods is through the use of Open Database Connectivity (ODBC). The following example will show the steps required to create a data access source, which can then be used by supported applications for accessing data through a data connection. The source used here will be an SQL Server 2005 database on a Windows XP operating system. To create a...
	Published 23 April 2009	Author scadadev.com	Views 2603

Using SQL to Create a Database Table
An easy way to create a new database table is through the use of an SQL (Structured Query Language) query. To execute SQL queries you will need to use the SQL query editor of your chosen database. For SQL server, use the Management studio to create a new query by right clicking on the database and selecting “New Query”. To create the table you must firstly specify the table name, and then the column names and data types within the brackets as illustrated below. You can specify as many col...
	Published 14 April 2009	Author scadadev.com	Views 2322

Using SQL to Insert a Row into a Database Table
A good way of inserting a new row into a database table is to use a SQL (Structured Query Language) query. To execute SQL queries you will need to use the SQL query editor of your chosen database. For SQL server, use the Management studio to create a new query by right clicking on the database and selecting “New Query”. To insert a new row, the table name must firstly be specified and then the column names for which the values are to be inserted into. The values section always comes after...
	Published 14 April 2009	Author scadadev.com	Views 1872