WebDocs Home | Show Navigation Hide Navigation

Getting Started with SQL Connection

SQL Connection is an API that enables Synergy applications to use SQLbased functions to access and manipulate data from various database systems. It consists of two types of functions:

Database functions are directly related to SQLbased 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.

Features and supported databases

Components and configurations

Installing, configuring, and initializing

Setting options and environment variables