You can get quite exotic with the expression,retcol syntax, but be careful that you don't get over the width for the menu box. This width is (20 + 1 + 15 + 1 +11 + 1 +14) = 63, and will fit, but get over about 76 and you are in trouble. This is DOS - IN rbWin you need to add the FORMATTED clause if you are trying to line things up like this, and play with the title to make it work right.
CHOOSE vtEmplID FROM #VALUES FOR + (LJS(LastName,20) & LJS(FirstName,15) & LJS(SSN,11) & + LJS(HomePhone,14)),EmplID + FROM Employees + AT CENTER,CENTER TITLE + 'LastName FirstName SSN Home Phone No.' + ORDER BY LastName,FirstName Dan Champion <[EMAIL PROTECTED]> wrote: >Hi, > � �This whole business explains a few troubles I have had over the years. >Never realized it returned a text value. �Good thing to learn. >Two questions arise. >1. �In the example, Dennis gave, what does (retexpression) stand for. Not >like returncolumn right? �And the second question will probably better help >answer the first. > >2. In the 'Help' for select, the syntax (to an untrained 'wanna-be' >programmer such as myself), is very hard to understand. I realize that it >can be a very powerful tool in my kit, but I spend a lot of time 'trying' >code and looking at the syntax. �Is there a book or resource out there that >explains the select clause in greater detail? > >Thanks. > >At 10:49 AM 4/29/02 -0400, you wrote: >>In a message dated 4/29/2002 10:28:25 AM Eastern Daylight Time, >>[EMAIL PROTECTED] writes: >> >><< Before I create a choose command, I create and test a slect statement >>first. >> �That way, I will get �the correct error messages. �The ones returned from >> �choose can be VERY misleading. >> >> �SELECT (expression),(retexpression) FROM tblname WHERE clause .... >> >> �This will tell me if I will get what I want without errors. >> >> �Then I simply replace "SELECT" with "CHOOSE varname[, retcol] FROM #VALUES >> �FOR" >> �and tack on the "AT scrnrow scrncol ......" syntax >> >>Dennis, >>In the select (expression), are you sayiong I can concentenate a group of >>columns as an expression and choose from the concantenation? If so, are there >>any limitations such as length ? >>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/ > > > >Dan Champion >P.O. Box 223 >Grandville, MI. 49428-0223 >www.championsolutions.net > > >================================================ >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/
