Query Classes in General

Das Goravani goravanis at gmail.com
Wed Aug 24 16:47:18 UTC 2022


Hello,

I have not been able to find sufficient documentation on the Query Class subject in the Omnis documentation.

So I have some questions:

Is the basic use of a query class like this:

You set it up.. enter the columns from tables into the query that you want to be a part of it.

Then you define a SQL list or row in Omnis from the query class.

Then when you do a select with that query defined list you get the joined results. 

That’s it right? That’s the basic use of a query class, correct?



Next question:

You cannot INSERT or UPDATE with a query defined list or row rather..  correct?

You cannot do Data Writes with that query defined list because it is more than one table, correct?


So in the end a query class is just a way to do joins, selects. Instead of writing it in SQL, you use the query class. Correct?


That’s it. 

Thanks

Das Goravani


More information about the omnisdev-en mailing list