Query class question

jim jpcr.com jim at jpcr.com
Mon Nov 20 13:52:58 UTC 2023

Hi Mike,

This might be your problem: You need a table class linked to the query class, just like the table class that you have linked to the schema class.


Jim Pistrang
JP Computer Resources

On Nov 20, 2023, at 8:35 AM, Mike Rowan <mgrowan at fastmail.com> wrote:

I am sorry to bother the list again with something that's probably simple, but I'm stuck.

I have a PG table of data. I have an Omnis schema and table class for it. I want to load the data into a list, so I do this:
Do iList.$definefromsqlclass('tauthors')
Do iList.$select() Returns #F
Do iList.$fetch(kfFetchAll)

That works.
Now I also have a query class, simplest possible. Every column from the sauthors Omnis schema only. No extra text.
If I change the above pseudocode slightly, to use the query, as in:
Do iList.$definefromsqlclass('qauthors')
Do iList.$select() Returns #F
Do iList.$fetch(kFetchAll)
it fails with #F = 0 though the column names are correctly shown in the list.  I don't understand why. Any hint would be welcome. As would a pointer to any more descriptive documentation than I've been able to find in the official online docs.

Mike Rowan
Mobile: 0417 812 509
Email: mgrowan at fastmail.com
Manage your list subscriptions at https://lists.omnis-dev.com
Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com

More information about the omnisdev-en mailing list