APPX is the Premier Development and Runtime Environment for Business Application Software
(Answer) (Category) FAQ's - APPX Software, Inc. : (Category) APPX Utility : (Category) APPX Development Environment : (Category) Query Processes :
Query stops before processing entire file!
When running a job/update process that uses a query, we got an Appx error during the selecting records phase. This was about 10000 records into the file, out of ~180000, and stated that it couldn't scratch the work file because the record length was invalid.
That's caused by a known bug in earlier versions of Appx. You can work around that problem by setting an environment variable, try this:
This tells Appx to allocate 2MB to process a give query before it falls back to using an on-disk sort strategy.
[Append to This Answer]
2003-Nov-20 11:10am
Next: (Answer) Why doesn’t my QUERY use the file’s index?
This document is:
[Search] [Appearance]
This is a Faq-O-Matic 2.719.
Copyright 2003 by APPX Software, Inc. All rights reserved.