× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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
+---

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.