NewEra2.2 Memory Error

SmartHeapError. In NewEra 2.2 my SuperTable SelectFromPart reads: locatn, dinv, minv, product, mfg, outer mat_cnt, outer nsn, outer msds. The SelectJoinPart reads: locatn.loc_id=dinv.loc_id and dinv.minv_id=minv.minv_id and minv.prod_id = product.prod_id and product.mfg_id=mfg.mfg_id and minv.matcnt_id = mat_cnt.mat_cnt.id and minv.nsn_id=nsn.nsn.id and product.msds_id=msds.msds_id When a default query is executed (which attempts to retrieve approximately 8,000 plus records) the program cashes with the error SmartHeapLibrary Out of Memory, Please free some memory then choose retry. I ran some memory diagnostics there seems to be a problem in that the NewEra2.2 exe is not using swap. My development is Windows95 NewEra2.2 using Window Painter AppBuilder using the BreakConstructor Function to split constructors > 64K Application Frame Work Class Library New Era Standard Class Library MSVC Complier DataBase Engines are SE and On-Line Dynamic Server. The program crashes on both. I'm thinking that 1. There is some parameter that can be set to solve the problem. 2. NewEra2.2 will not use windows disk swapping for memory. In which case I will have to code a maxrows event to prevent the error. Any thoughts? Ed Gerving (egerving@htscm.com) Computer Sciences Corporation