AW: Query class question

[Rudolf Bargholz]

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 ?

Regards

Rudolf Bargholz

-----Ursprüngliche Nachricht-----
Von: omnisdev-en <omnisdev-en-bounces at lists.omnis-dev.com> Im Auftrag von Mike Rowan
Gesendet: Montag, 20. November 2023 14:35
An: OmnisDev List - English <omnisdev-en at lists.omnis-dev.com>
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 fastmail.com
_____________________________________________________________
Manage your list subscriptions at https://lists.omnis-dev.com Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com