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/
