Tuscany, Italy

4 days / 20 talks
Awesome and great speakers

October 16-21

David Barnet

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.

A Close Look At Lists and Trees

Learn details about using and managing Lists, comparing classic commands versus list notation. And a look at the Studio Tree, a handy, but often misunderstood window object.

Using Lists are a main part of Studio programming. We will look closely at classic list commands and list notation, and show many examples of how (and when) to use them. When to write a loop versus using a $sendall, for example.

We will also take a look at the Studio Tree object. It’s often called a ‘Tree List’, but isn’t always based on the contents of a list. We will also look at other list-based window objects as time allows.

This session will be of particular interest for developers converting code from older versions of Omnis into Studio and those still relatively new to Omnis.

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