Query Classes in General
goravanis at gmail.com
Mon Aug 29 16:09:47 UTC 2022
So the Extra Query Text at the bottom of the Query window allows you to enter your WHERE clause there, and therein you can thus put your joins ie WHERE PrimaryKey=ForeignKey AND PK2=FK2 etc. You can also alter the FROM clause by in table class connected to Query
Calculate $cinst.$fromclause as ’tableXYZ JOIN tableABC ON PK=FK
Then on the subject of updating and inserting with a Query Generated Row or list:
Doug said you have to remove the columns from the secondary tables, leaving only columns from your main table.
Is that correct? You have to remove the extra columns?
And the main benefit of doing Query’s with a Table Class is that you can do methods straight off the list, ie:
Have I got the details now?
More information about the omnisdev-en