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.
For an overview of the steps you will need to follow to use SQL Connection in your Synergy program, see Writing an SQL Connection program.
Features and supported databases
