PxPlus User Forum

Twitter Twitter Twitter

Author Topic: Query problems  (Read 2173 times)

edjack

  • Silver Member
  • ***
  • Posts: 44
  • Computerease
    • View Profile
Query problems
« 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?
Ed Jack
Computerease

edjack

  • Silver Member
  • ***
  • Posts: 44
  • Computerease
    • View Profile
Re: Query problems
« Reply #1 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?

Ed Jack
Computerease

edjack

  • Silver Member
  • ***
  • Posts: 44
  • Computerease
    • View Profile
Re: Query problems
« Reply #2 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
Ed Jack
Computerease