Thanks, Gary. You are right-the limit is controlled through the preferences form and it bleeds over to the midtier, too. However, that, ultimately, was not the source of my trouble.
I figured out that if you set a max number of rows to be displayed in a table in version 5.1.2 of the midtier (don't know if this happens in 6.0+), if you refresh the table and, say, seven database records match the table's qualification, the midtier throws ARWARN 66!!! The client doesn't, but the midtier does. I'm curious to know if this happens in 6.3+. Norm _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L Contr OC-ALC/ITMA Sent: Tuesday, February 13, 2007 1:33 PM To: [email protected] Subject: Re: Limit Number of Items Returned on the Midtier I think you can use the AR System User Preferences form to control this on the web. https://......../AR+System+User+Preference/Default+Administrator+View/ <https://......../AR+System+User+Preference/Default+Administrator+View/> You might give that a go, and this is on 6.3, so you might have different results. _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CG/SCWOE Sent: Tuesday, February 13, 2007 1:13 PM To: [email protected] Subject: Limit Number of Items Returned on the Midtier Hi everyone: Please refresh my memory. I seem to recall there's a fairly easy way to limit the number of items returned when executing a search on the midtier. In the client it's an option setting that gets pushed to the user preferences form. How is the same reproduced on the midtier? My application is throwing the "The query matched more that the maximum number of entries specified for retrieval" (ARWARN 66) when I run my app in the midtier but I don't get it when running it in the client. Thoughts? Norm __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"

