4 days / 20 talks
Awesome and great speakers

November 3-8

David Barnett

David is a longtime Omnis user, in the 30 year club (since 1985). His very first system, a music licensing system, is still in use after a major rewrite for Studio. He has developed systems for JP Morgan and American Express, amongst others. He has worked at companies with major Omnis-based systems such as Harris and Electra Information Systems (his current employer). David has taught sessions at numerous Omnis conferences in both Europe, the United States and Canada, and has always enjoyed playing keyboard with the Omnis band.

Automated Application Testing

There is more than one way to skin the testing cat! You can now compare two different techniques for testing.

A demonstration of an automated testing system developed in-house for testing the operation of an Omnis application. The system combines a Python-based tool which picks up test scripts built in Excel, and runs the script by firing off calls to an Omnis remote task to trigger test fixtures (objects built in Omnis) to operate different parts of the Omnis application. The tests cover most application operations, interface manipulations and reporting features to confirm that every part of the application continues to operate as expected as fixes are done and new features are added. This is not an ‘available product’, but an interesting combination of Omnis with other technologies that might inspire others to purse testing their own applications.

SQL That Works For You

A look at powerful SQL commands that do a lot of work for you: Merge, Analytic functions, Common Table Expressions, Group By Rollup/Grouping Sets, and more.

We’ve all had to do it. Bring lots of data back to Omnis to process or summarize before presenting on screen or printing. Or execute many calls to the database to figure out if records exist already before revising or inserting data. This session will look at powerful SQL commands that can do a lot of work for you in a single SQL call, avoiding many of those extra round trips.

We will look at the MERGE command to insert or update records based on what’s already in the database; at various Analytic functions that do ranking, percentages and row numbering based on what’s in the result set; at Common Table Expressions for making your sql calls more efficient; and at Group By Rollup and Grouping Sets to generate multi-level subtotals for reporting without depending on the Studio reporting tools.

As time permits we will look at other SQL functions that can be handy in your application. This session will focus on the SQL side of things. It will not cover how to connect Studio to a database or use Studio sql classes. How you ultimately use these SQL techniques in your application will be up to you.



Follow David



About workshops


You’ll sign up for the session you want to attend on a first-come, first-served basis. Up to 6 participants may attend a session, if full, you can sign up for the same topic at a different time. During the session, the speaker will guide the audience through the main topic but you will be able to ask him/her to deviate and cover related areas. Sometimes participants offer new ideas and solutions to a problem.

Check the


Pursue any question or area not directly related to the core topic. Every speaker hosts at least 4 sessions which means there are about 11 to 12 simultaneous sessions running all the time with an average of 5 or 6 participants

Meet the Speakers

Check the


Flexible conference format means you can choose the best classes for you and at the best time. Some sessions will be repeated, so when you miss one, you can attend the same session later in the day or the week.

Check the Schedule