AW: Query class question

Rudolf Bargholz rudolf at
Mon Nov 20 14:53:47 UTC 2023

Hi Mike,

You could try to set the extraquerytext to " where 1 = 1 ". Perhaps a missing extraquerytext is being interpreted as an error. Have you checked the iList.$errortext and iList.$sqltext ?


Rudolf Bargholz

-----Ursprüngliche Nachricht-----
Von: omnisdev-en <omnisdev-en-bounces at> Im Auftrag von Mike Rowan
Gesendet: Montag, 20. November 2023 14:35
An: OmnisDev List - English <omnisdev-en at>
Betreff: Query class question

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
Manage your list subscriptions at Start a new message -> mailto:omnisdev-en at 

More information about the omnisdev-en mailing list