Re: Computed columns? numeric to text conversion?

In article <43s0jg$kj5@cssun.mathcs.emory.edu> cwakins@leia.alloys.rmc.com (Clem Akins) writes: >On Thu, 21 Sep 1995 00:16:13 GMT Kate wrote: > >> I need to have or simulate a computed column in ISQL. I have two integer >> columns and I need to concatenate them into a third column. Any suggestions? > >RTFM. "Informix Guide to SQL Tutorial", v7.1, December 1994. >Part No. 000-7634. Index, page 6 under "Concatenation Operator" >See "Control Blocks", too. Fine. I can see how to concatenate strings. The question was about converting integers to strings and then concatenating them. > >Thu, 21 Sep 1995 02:23:48 GMT (two hours later!) Kate wrote more: Good to see you so concerned about WHEN I post! > >> How do I simulate a computed column in Informix? > >We don't simulate them, we use them. Thankyou. I wondered how. Couldn't see it anywhere in the manuals. > >> I need to concatenate two numbers so first have to convert them to text. > >No, you don't. Thankyou. > >> Is there a convert to text function. > >For this operation it doesn't matter. > >> Is there any way of simulating a computed column? > >Sure. Thankyou. Very informative! > >> Thanks in advance, >> >> Kate > >Back to the original message... > >> Also is there any way to have a one to many set up in FORMS? >> >> i.e. Can I display an order header and then have a list of line items >> displayed below? I can't work out from reading the manual how to get a >> form that will display this sort of thing! >> >> e.g. >> >> Order number Customer number >> Customer addresss >> >> Line item 1 >> Line item 2 >> Line item n >> >> Thanks, >> >> Kate > >At last, a question that's not an embarrassment to answer. Yes, there is. You don't have to answer any. >There are at least a couple of ways, one with 4GL and one with ISQL. >In the 7.1 manuals they seem to have lost the section on FORMS, so I keep >a copy of the v4.0 manual handy "Informix SQL Reference Manual, Database >Tool Version 4.00, March 1990. Informix Part No. 000-7042. I'd understand >if you couldn't find this section. (I'll copy the informix documentation >people (again) with this letter so they'll know, too.) The way in ISQL Forms >is to use a master-detail relationship, joining the two tables. The >quickest example of this is in the user menu provided by Informix. I found the section. However it appears you can only display one detail row at a time and I was wanting to show ALL the manys for a single "1". > >There is a better way in 4GL, which can be written as a pretty slick reader >with a total count, "current record" indicator, and other bells and whistles. >Of course it costs extra. > >"...When I don't know the answer, I read a manual. I openly ask vendors >to solve problems. I hire consultants. I go to school. I work nights >and weekends..." > 'I am not a wizard' > Computerworld, 1990 > > __________________________________________________________________ > | Clem Akins Standard Disclaimers Apply | > |Reynolds Metals Co, Alloys Plant "Climb High, Cave Deep!" | > | Muscle Shoals, Alabama USA cwakins@leia.alloys.rmc.com | > |________________________________________________________________|