Re: Computed columns? numeric to text conversion?

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. Thu, 21 Sep 1995 02:23:48 GMT (two hours later!) Kate wrote more: > How do I simulate a computed column in Informix? We don't simulate them, we use them. > I need to concatenate two numbers so first have to convert them to text. No, you don't. > Is there a convert to text function. For this operation it doesn't matter. > Is there any way of simulating a computed column? Sure. > 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. 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. 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 | |________________________________________________________________|