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.
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.