Query class question

Mike Rowan mgrowan at fastmail.com
Mon Nov 20 13:35:01 UTC 2023

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

More information about the omnisdev-en mailing list