Omnis Studio Database Connectivity

Learn to use Omnis Studio’s multi database connectivity: SQL implementation, connecting to any SQL server, using table classes and inheritance of table classes to implement common interfaces. Creating manual SQL using the query builder used in table classes. Creating a session pool.

•  Connecting to an SQL server
•  Writing a logon method to the SQL server
•  Using the Query Builder tool to generate a SQL join
•  Using table classes to execute SQL
•  Using list and row variables to load in a remote form and save data into the database