RE: Query question

[Jim Cannon <JimC@xxxxxxxxxxxxxxxxxxx>]

Thanks for the idea.

> -----Original Message-----
> From: stewart@prok.com.au [SMTP:stewart@prok.com.au]
> Sent: Friday, August 18, 2000 12:33 AM
> To:   MIDRANGE-L@midrange.com
> Subject:      RE: Query question
> 
> 
> another way:
> create a little file called ONOFF
> with two fields, OOVAL (alpha 1), and OOTEXT (alpha3)
> use a dfu to create the two records
> 0 OFF
> 1 ON
> in the qry, join each feild that you wish to xlate
> to OOVAL (you will need three joins with ONOFF),
> and pick up the required OOTEXT.
> 
> 
> 
> At 15:57 17/08/2000 -0700, you wrote:
> >Thanks. I received several similar solutions. Not what I was hoping for.
> I
> >sure hope the simple elegant solution comes by. The file I am working
> with
> >has at least five of these fields.
> >
> >
> >> -----Original Message-----
> >> From:      Joel Fritz [SMTP:JFritz@sharperimage.com]
> >> Sent:      Thursday, August 17, 2000 2:48 PM
> >> To:        'MIDRANGE-L@midrange.com'
> >> Subject:   RE: Query question
> >> 
> >> There's probably a simple elegant solution I don't know, but...
> >> 
> >> I'd do two passes to an outfile, appending the results on the second
> pass,
> >> selecting for the flag equal '1' and then '2'.  Create a result field
> with
> >> value "On" for the query that selects '1' and change its value to "Off"
> >> for
> >> the query that selects '0'.  Use the result field in the outfile.  
> >> 
> >> Then run a third query over the outfile sorting the results the way you
> >> want
> >> them to appear.  
> >> 
> >> I'll bet someone has a better idea, though.
> >> 
> >> > -----Original Message-----
> >> > From: Jim Cannon [mailto:JimC@Arizonabiltmore.com]
> >> > Sent: Thursday, August 17, 2000 12:35 PM
> >> > To: 'midrange-l@midrange.com'
> >> > Subject: Query question
> >> > 
> >> > 
> >> > I have a one byte character field that contains either '0' or 
> >> > '1'. I don't
> >> > want to print the character on the report. Instead I want to 
> >> > print "On" for
> >> > the character 1, and "Off" for the character 0.
> >> > 
> >> > I can't find how to do this. 
> >> > 
> >> > Thanks in advance
> >> > 
> >> > Jim Cannon       
> >> > Information Systems
> >> > Arizona Biltmore Resort & Spa
> >> > 602-954-2569
> >> > 
> >> > 
> >> > 
> >> +---
> >> | This is the Midrange System Mailing List!
> >> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> >> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> >> | To unsubscribe from this list send email to
> >> MIDRANGE-L-UNSUB@midrange.com.
> >> | Questions should be directed to the list owner/operator:
> >> david@midrange.com
> >> +---
> >+---
> >| This is the Midrange System Mailing List!
> >| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> >| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> >| To unsubscribe from this list send email to
> MIDRANGE-L-UNSUB@midrange.com.
> >| Questions should be directed to the list owner/operator:
> david@midrange.com
> >+---
> >
> >
> 
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> david@midrange.com
> +---
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---