Thanks to all who answered my two questions. I will get the book(s) mentioned.
Dan At 11:30 AM 4/29/02 -0500, you wrote: >Dan - > >Contact David Blocker [EMAIL PROTECTED] > >He has some great published materials and sample database files. He (we) >used to teach a full course in using the SELECT statement, ending with a fun >problem that calculated a golfer's handicap using one (really BIG) select >statement. > >Sami > >----------------------------------------------------------- >Sami Aaron >Software Management Specialists >19312 W 63rd Terr >Shawnee KS 66218 >913-915-1971 >http://www.softwaremgmt.com > >----- Original Message ----- >From: "Dan Champion" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Monday, April 29, 2002 10:34 AM >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/ 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/
