|
Interesting observation. I thought query/400 always read all records before deciding which ones it did not need, unlike RPG & SQL that only read the ones that you specify. So for example, I do a calculated field, then select only those records in which the divide by field is not zero & the query bombs because of divide by zero, because it is doing the divide before it does the not zero, but if I make the math divide by (whatever value + 0.00001) it correctly excludes the whatever value when zero & does not blow up again until we have a case of that value being 0.00001- > hey all, > > quick question: does anyone know when/what makes query/400 decide it must > read all records for the query before displaying the first page? > > I use query a lot for quick one-off reports, mostly for my own analysis, > and in some complicated querys (joins, sorting on fields from different > files, etc) the query reads through all records before displaying the first > page. > > sometimes, by omitting just one field from the sort, it won't have to read > the whole thing. > > just curious, TIA. > > rick > MacWheel99@aol.com (Alister Wm Macintyre) (Al Mac) BPCS 405 CD Manager / Programmer @ Global Wire Technologies Incorporated http://www.globalwiretechnologies.com = new name same quality wire engineering company: fax # 812-424-6838 Sep 11 Favorite Links: http://www.nzherald.co.nz/pdf/middle_east.pdf http://www.semitrue.com/thankyou/ http://groups.yahoo.com/group/TYR http://www.skirsch.com/politics/plane/disable.htm http://www.geocities.com/wasabidoh/Pictures.html - select Attack on America Newspapers World Wide http://www.wheretodoresearch.com/news/foreign_newspapers.htm http://www.wheretodoresearch.com/news/US_Newspapers.htm Intelligence Briefings by country http://www.nsdmg.org - click on REAL WORLD RESOURCES http://www.c-span.org/international/links.asp http://www.cnn.com/2001/WORLD/asiapcf/central/09/17/asia.support/ http://www.odci.gov/cia/publications/factbook/geos/af.html http://www.economist.com/countries http://www.washingtonpost.com/wp-dyn/world/search/list/index.html http://www.debka.com/ http://www.stratfor.com
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.