PxPlus User Forum

Main Board => Discussions => Nomads => Topic started by: edjack on July 09, 2018, 10:29:12 AM

Title: Query problems
Post by: edjack on July 09, 2018, 10:29:12 AM

Using version 13.1
Defined querys will not pre-sort by alternate key.
Have tried classic and + options and many other combinations.
It will on random occasions sort by the alternate key, but then switches back to a default alternate key.
what options shouild i be looking at?

Title: Re: Query problems
Post by: edjack on July 09, 2018, 02:25:03 PM

More info...

If I do not run our application the query loads with the proper alternate key.

What %nomads variable will prevent a query from loading an alternate key?

Title: Re: Query problems
Post by: edjack on July 09, 2018, 02:32:27 PM

Found the problem... A program was setting %NOMAD_QUERY_KNO=1 and this was overriding the query definition.

Solved Now