Back

Topic

[KB410]SVSQL Project

Sample projects
15 years ago
By RM
Options
Print
Applies to:

PcVue version 7.20c and version 11.0.
In general if a project is used with a later version of PcVue it will be automatically converted to that version. Occasionally it may be necessary to make manual modifications.
Summary:

 Use of the SCADA Basic instruction SVSQL to manage an ODBC compliant database using SQL (Standard Query Language) commands.

The following modes of SVSQL are used:

  • CONNECT
  • DISCONNECT
  • EXECUTE
  • FETCH
  • GETROW
  • ERROR

As of version 12, the use of pre-configured Sql connections along with SQL_CONNECTION and SQL_COMMAND is preferred to using the verb SVSQL.
Details:

 
Sample project:

Created on: 11 Feb 2011 Last update: 13 May 2024