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/
