Damon, the list returned is too many items. How we get around this is to dialog a filter on the first character(s) of the list before popping up the menu.
SET VAR vNameSearch TEXT = NULL SET VAR vKey TEXT = NULL DIALOG 'First letter of name' vNameSearch=3, vKey 1 SET VAR vNameSearch = (.vNameSearch + '%') CHOOSE ... WHERE CompanyName LIKE .vNameSearch [EMAIL PROTECTED] wrote: >I'm doing an order by clause in a pop up menu in a form, and I keep getting >the following error message: >Insufficient memory to continue this operation. >The where and order bt clause are: >WHERE PRODTBLE.PRODNMBR > 0 ORDER BY PRODTBLE.PRODNMBR DESC >The where and order by test OK in the where builder, so what am I missing? >I'm still using RBWin 6.5++, Build 1.842xRT03 > >(Yes, Razzak, I downloaded the patches, just haven't installed them yet <g>) > >TIA. >Damon > >Damon D. Kaufman >President >Stalder Spring Works, Inc >ISO-9002 / QS-9000 Certified >2345 S. Yellow Springs St. >Springfield, Ohio 45506 >Voice 937-322-6120 >Fax 937-322-2126 >email: [EMAIL PROTECTED] >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ > -- __________________________________________________________________ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
