This is a follow-up to Sami: I have taken David Blockers' Beginning and Advanced classes for R:Base and found them to be invaluable. I have only been working with R:Base 6.5 + since October 2000 and it was David's courses that got me up to speed. I highly recommend both the course's and book's.
Rich Starkey United Community Services of America -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Dan Champion Sent: Monday, April 29, 2002 11:35 AM To: [EMAIL PROTECTED] Subject: Re: CHOOSE syntax 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/ ================================================ 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/
