Approaching Omnis again scares me, too much to learn?

Andreas Pfeiffer apfeiffer at
Thu Jan 4 09:47:23 EST 2018


To learn SQL check out the Query Builder that is available in the Omnis UI.

Once you have a SQL connection (that also can be an Omnis datafile) you can drag server tables to the white design space. Start with one table first. Select the columns that you want to display and click build&run. Then you can add a „Where clause“ to it.

Provided you have foreign keys in the tables (these are the fields that store the primary key value of the connected server table) you might then add another table and use the mouse to drag a line from the primary key of the father table to the foreign key of the child table. That generates the join.

Once you have a working SQL check out the additional button „other“. That allows you to create a table class that will have a method "$build“ or "$load“ inside that contains the statement you have designed.

Then create a window or a remote form and make an instance variable there. Chose as a subtype the table class that has been generated. Then you can do the following in the $construct of the window or form (let’s say your list is called iDataList):

Do iDataList.$build()

Voila you have a SQL working. This code is going to load the data into the list.

All you need is a grid that will have the list name in its $dataname.

I hope this gives you a start. Also check out the video number 2 and 5 at



> Am 04.01.2018 um 15:14 schrieb Jerry Greenberg <jerry at>:
> Hi Das, basic SQL is actually pretty simple and for most desktop/dml type apps that's all you'll really need.  Sure for ultimate efficiency you can create some complex SQL but for smaller apps it's really not necessary.  Learn the strategies of connecting your tables, learn your joins and you'll be off to a running start.
> As you may recall I have been around Omnis since the 80s as well, and for a while on the Omnis Consulting team, and I have worked with many of the developers here and on numerous large projects and I think my best advice for you is this.  Understand that much of what you read here on the list comes from developers that have or currently work on multi developer teams, for large companies, and on very large projects, and the techniques they use have some great advantages in that environment.  But, to try and implement those techniques in a single developer environment is most likely counter productive, daunting and complex.  You may want to learn some of those techniques down the line but you don't have to use them.
> My suggestion is to learn basic sql, and forget about table classes, and query classes for now. (if you use them you won't be learning your sql)  Just use the schema classes, define your lists and rows from the schema classes, create some select statements, and use your notation skills to access the data.  It's a good start.
> oh btw. the sqllite database is a great little database which I look at as a great replacement to the datafile.
> Good luck,
> Jerry
> At 03:55 PM 1/2/2018, you wrote:
>> Hello All, I am RE approaching Omnis with a view to becoming a developer/consultant to businesses. I am completely expert with Omnis and the native database it provides, but don’t know SQL or anything else, I only know Omnis. I don’t know any other language at all.  I go back to 86 but haven’t done anything for ten years.  It’s scary enough to have to learn SQL and how to connect to databases.  But all the stuff you guys and gals discuss here and on the other forum scares me.  How did you all learn all about Java and Jason and Restful etc etc.  How do you keep it straight in your heads? My real question is this:  If I could learn SQL and how to setup and maintain backends and the connectivity, is that enough to be a consultant today?  I imagine right away the next point is that businesses will want phone access apps, tablet apps, to access their databases and then I’d be looking at Javascript which I don’t know. At age 57 and reapproaching, I wonder how much time it takes to learn these things and begin consulting. Are all these fancy other things smaller than Omnis learning itself?  I sure hope so.  It took a good while to learn Omnis.  I’m very good at Omnis but only Omnis Native.  Don’t yet know what a Schema is, but I can do notation to control anything, I can do complex interfaces and handle complex data.  Just dont know anything else.  Do any businesses still go for using the Native Datafile?  With that I’m ready already. One reason I want to learn SQL is to earn more.  The businesses for which the Native datafile is appropriate are smaller and poorer.  I believe you can charge more to the SQL requiring businesses.  Comments? Is the "Lone Developer" still possible?   You all seem to be in teams. Just scared badly.   Any help appreciated. _____________________________________________________________ Manage your list subscriptions at
> _____________________________________________________________
> Manage your list subscriptions at



More information about the omnisdev-en mailing list