Getting Started with SQL Connection

SQL Connection is an API and a set of database drivers that enable Synergy applications to use SQL-based functions to access and manipulate data from various database systems, such as Oracle and SQL Server. The SQL Connection API consists of two types of functions:

Database functions are directly related to SQL-based operations and data access. They greatly simplify application development by reducing the number of calls needed to accomplish a wide variety of SQL functions. See Database Functions.

Utility functions enable you to get information, map error codes, and set date and time options during the execution of a Synergy application. See Utility Functions.

Every SQL Connection function generates a value and can be used any place a literal can be used in a Synergy program. Except where noted, SQL Connection functions work with both traditional Synergy and Synergy .NET.