powerh-l digest, Vol 1 #492 - 10 msgs
Terry Pickering
pickering@4j.lane.edu
Wed, 30 Oct 2002 11:38:06 -0800
I think one works "on and off", the other I don't know. They would best
probably be used for parts or someone that can repair them.
At 01:22 PM 10/30/2002 -0600, you wrote:
>Send powerh-l mailing list submissions to
> powerh-l@lists.swau.edu
>
>To subscribe or unsubscribe via the web, visit
> http://lists.swau.edu/mailman/listinfo/powerh-l
>or, via email, send a message with subject or body 'help' to
> powerh-l-request@lists.swau.edu
>You can reach the person managing the list at
> powerh-l-admin@lists.swau.edu
>
>When replying, please edit your Subject line so it is more specific than
>"Re: Contents of powerh-l digest..."
>
>
>Today's Topics:
>
> 1. RE:Solution found RE: Find procedure problems with Powerhouse 8.
> 39 (Deskin, Bob)
> 2. Qdesign - Sorting Question (Catherine Litten)
> 3. PowerHouse Pricing Questions (Berry, Robert)
> 4. RE:Qdesign - Sorting Question (David Morrison - Corporate)
> 5. RE:Qdesign - Sorting Question (Hasse, Christina)
> 6. RE:Qdesign - Sorting Question (Johnson, Harold A EDUC:EX)
> 7. RE:Qdesign - Sorting Question (Nancy Tietz)
> 8. RE:Qdesign - Sorting Question (Whittall, Conrad)
> 9. RE:Qdesign - Sorting Question (Nancy Tietz)
>
>--__--__--
>
>Message: 1
>From: "Deskin, Bob" <Bob.Deskin@Cognos.COM>
>To: powerh-l@lists.swau.edu
>Subject: RE: Solution found RE: Find procedure problems with Powerhouse 8.
>39
>Date: Wed, 30 Oct 2002 07:45:49 -0500
>
>I'm not sure why this ever worked. Unless you retrieve a PRIMARY file record
>in the FIND procedure, you'll never proceed to the POSTFIND or further.
>Unless there's missing information. I notice that the files you list aren't
>all mentioned in your procedures. Sounds like a bug that was fixed.
>
>Bob Deskin
>PowerHouse Web Product Manager, Application Development Tools, Cognos Inc.
>bob.deskin@cognos.com (613) 738-1338 ext 7268 FAX: (613) 727-1178
>3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA
>
>-----Original Message-----
>From: Sherry_Baillie@gov.nt.ca [mailto:Sherry_Baillie@gov.nt.ca]
>Sent: Tuesday, October 29, 2002 6:37 PM
>To: powerh-l@lists.swau.edu
>Subject: Solution found RE: Find procedure problems with Powerhouse 8.39
>
>
>
>No need for further responses - solution found.
>
>I changed the FIND procedure to a DETAIL FIND procedure and voila.
>
>Interesting why this worked in pre 8.39 versions.........
>
>Thanks to all respondents!
>
>Sherry
>
>-----Original Message-----
>From: Sherry Baillie /YK /JUS
>Sent: Tuesday, October 29, 2002 3:52 PM
>To: 'powerh-l@lists.swau.edu'
>Subject: Find procedure problems with Powerhouse 8.39
>
>
>Help! I'm having a difficult time trying to identify a problem I'm
>having with a quick screen since upgrading to PH8.39 for MPE.
>
>The intention of the screen is to automatically display information to
>screen based on a passed parameter.
>
>With version 8.39 nothing is being displayed from the detail file. I've
>included the files and applicable code below.
>
>Has anyone else come across the same problem and how do I rectify?
>
>Thanks.
>
>Sherry
>
>
>Files:
>file PERSON primary
> access via PERSON-IDX using p-person
>
>file CHARGE alias CHARGE-SEC secondary
> access via PERSON-IDX using PERSON-IDX of PERSON
>
>file DISPOSITION alias DISP-SEC secondary occurs with CHARGE-SEC
> access via CHARGE-IDX using CHARGE-IDX of CHARGE-SEC
>
>file disp-obl detail occurs 6 noitems
> access via DISP-DETAIL-IDX using DISP-DETAIL-IDX of DISP-SEC
>
>file disp-detail SECONDARY occurs with disp-obl noitems
> access via disp-detail-idx using disp-detail-idx of disp-obl
>
> > procedure FIND
> > begin
> > for DISP-OBL
>*W* FOR loop without missing option in FIND procedure. Scrolling cache
>commands should be avoided.
> > begin
> > get DISP-OBL-REF via PERSON-IDX using PERSON-IDX of PERSON
> > get DISP-REF via DISP-DETAIL-IDX using DISP-DETAIL-IDX of
>DISP-OBL-REF
> > get SWORN-REF via SI-IDX using SI-IDX of DISP-REF
> > if INFO-TYPE of SWORN-REF ne "C"
> > then get DISP-OBL via OBL-IDX using OBL-IDX of DISP-OBL-REF
> > end
> > end
> >
> >
> > procedure postfind
> > begin
> > let t-count = 0
> > while retrieving obl-chk via person-idx using person-idx of person
> > begin
> > let t-count = 1
> > break
> > end
> > if t-count = 0
> > then push next data
> > end
> >
> > procedure detail postfind
> > begin
> > for disp-obl
> > begin
> > info = info-type of sworn-info now resp
> > if INFO-TYPE of SWORN-INFO ne "C"
> > then begin
> > let t-warrant = warrant-status of disp-detail
> > if filler30 of disp-obl <> " "
> > then do internal display-bail
> > else do internal display-disp
> > end
> > end
> > end
> >
>
>
>
>Sherry Baillie
>Systems Analyst
>Department of Justice
>Government of the Northwest Territories
>
>
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l@lists.swau.edu
>Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
>Unsubscribe: "unsubscribe" in message body to
>powerh-l-request@lists.swau.edu
>http://lists.swau.edu/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.
>
>This message may contain privileged and/or confidential information. If you
>have received this e-mail in error or are not the intended recipient, you
>may not use, copy, disseminate or distribute it; do not open any
>attachments, delete it immediately from your system and notify the sender
>promptly by e-mail that you have done so. Thank you.
>
>--__--__--
>
>Message: 2
>Reply-To: <catherine.litten@valleypres.org>
>From: "Catherine Litten" <catherine.litten@valleypres.org>
>To: "Powerhouse List Server" <powerh-l@lists.swau.edu>
>Subject: Qdesign - Sorting Question
>Date: Wed, 30 Oct 2002 10:41:48 -0800
>boundary="----=_NextPart_000_0008_01C28000.F2FEDEE0"
>
>This is a multi-part message in MIME format.
>
>------=_NextPart_000_0008_01C28000.F2FEDEE0
>Content-Type: text/plain;
> charset="iso-8859-1"
>Content-Transfer-Encoding: 8bit
>
>I am rather stagnant in my use of QDesign - I usually develop simple screens
>with little more than redefines of data and data population based on user
>responses. However, this time I have a user that wants a screen that is
>really much like a report. This is just a find screen that lists who is on
>suspension (usually less than a screen full) They would like this in alpha
>order by last name and name is not a key field.
>
>Any recommendations on how to show the data sorted the way they like
>(usually I just tell them they need a quiz report instead of a screen)
>without changing the structure of the database?
>
>Thank you,
>Catherine
>
>
>
>*****************************
>Catherine Litten, Sr. Programmer/Analyst, Valley Presbyterian Hospital
> 15107 Vanowen Street, Van Nuys, CA 91405 (818)782.6600 x 2140
>catherine.litten@valleypres.org
>********************************
>The thoughts, comments, and opinions expressed herein are mine. They do not
>reflect those of my employer, nor anyone else.
>********************************
>This E-mail is covered by the Electronic Communications Privacy Act, 18
>U.S.C. §§ 2510-2521 and is legally privileged. This information is
>confidential information and is intended only for the use of the individual
>or entity named above. If the reader of this message is not the intended
>recipient, you are hereby notified that any dissemination, distribution or
>copying of this communication is strictly prohibited. If you have received
>this transmission in error, please notify the sender immediately by return
>electronic transmission and then immediately delete this transmission.
>
>
>------=_NextPart_000_0008_01C28000.F2FEDEE0
>Content-Type: application/ms-tnef;
> name="winmail.dat"
>Content-Transfer-Encoding: base64
>Content-Disposition: attachment;
> filename="winmail.dat"
>
>eJ8+IjASAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
>b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEGgAMADgAAANIHCgAeAAoAKQAAAAMANwEB
>A5AGAJQJAAAiAAAACwACAAEAAAALACMAAAAAAAMAJgAAAAAACwApAAAAAAADADYAAAAAAB4AcAAB
>AAAAGwAAAFFkZXNpZ24gLSBTb3J0aW5nIFF1ZXN0aW9uAAACAXEAAQAAABYAAAABwoBEARFCQKVG
>vSxAJaM5xCfeU93KAAACAR0MAQAAACUAAABTTVRQOkNBVEhFUklORS5MSVRURU5AVkFMTEVZUFJF
>Uy5PUkcAAAAACwABDgAAAABAAAYOAIY65EOAwgECAQoOAQAAABgAAAAAAAAA1x58DOAcw0O9RJMM
>Fq1CFsKAAAALAB8OAQAAAAIBCRABAAAAgQUAAH0FAACCCAAATFpGdXQ67LQDAAoAcmNwZzEyNRYy
>APgLYG4OEDAzM08B9wKkA+MCAGNoCsBzAGV0MCBFbnZpPQNgRAKDAFAC8hDHMiDSVwuAZ2QTUXMC
>gw5Q9xBvBxMCgzMDRRKZBrQCg8I0FD8gVGFoA3ECgGZ9CoAIyCA7CW8OIDjfGmMbgRrPCX4OMDUC
>gAqBKxGQB9BrC4BkF9B1YxMAUAsDbm8D8GRjdAZsCrELpTQgSSBhQG0gcmF0aASQIHJzAZBnbgBw
>BUALgCAQbXkgdREgIG9mKCBRRAeQaSIgIC1rISEi4HUHQGwiwAEAdvplCQBwIeAHcAtQIwAE8c8J
>4QQgA/AhoCBsJhAgUPcjAARgCXAgIaADkQlxARDXC4AHkSMhZCGQYSFAHyCVKCRwJOB1C2B0aQIg
>+CBiYREgKKApkSLhBcAdCXBzKRAAgAeQLiAg5kggACShciwnAQQAJwD/B3EhIRDwJLAhQCpEJxEF
>QP53IkEEIChgJYQtZCwRCXDtJENtH2AmMmss4glwKRDbACArMVQsAiwRaiLgBUD/KGAnoSigLkom
>UCHwJeEZIL8u8imRJCAqwCXBKYIoJBYvJVAEEScTLidmKUBsKdUw0mUiwHcIYGwooC/z9yvzIoEH
>QHAQ8CMQCyAhwf5iNREp0AVAIjAsYSiCOZN/LBEf8DGiMBAiwCegJMBkzysxCqIKhAqAQW4iwAlw
>/QWgbQeAHyApYzOjGSAH4Lp0M3BzPfMhsCgkcwkR/ynxPrItwCLAIaE1ETACNKf/ITAxcz9wJFA+
>oiFgQDMnwMMp8ShgcXVpejBVInH/IfAvQCoBIzAuJjagJgIIYL8FQBDhDyATUT6jIfByH2DedAhw
>IwM+tinCPzvKMPBRAHBrIHkIYCw7xEPvIZMnsTvIH9xxAOA72QjQ7xIiEjEL8jvTdk4PTslMhyMU
>IRQiMTggSfcgTKcmYQnwK9BTciswUANgZwnAIVAHgHIvPIAHQHn7IfAr0FYkQTbxUmAHkDkQ/z9w
>ByEDoCtgKsAmEAdAO7XoIDE1D0A3U5Ef8S6BnlNGoAngU3MDoE51U1ABK9BDQSA5MTQwEjUrQCg4
>UNApNzggMi42NjARUHggbjJYITu2TPAzRbBKBi5TJlIJ8EB2U7NwKqEu/QWwZ0yPEVAEEF2/XpsV
>0n871ACgF8NQ0TbRJwEIYGf+aC3wK9A85GGCKIIk4AuAuT1zZXhb8iniIbFlOCLtJuFtWuI2tWQz
>cDqiCXD/DvAFkEGxGSAi9CKxQkALUPxveSuyH/AFwABwSVBRcfskwBEgLl/WAtFdP2pPX1TPSplU
>QA9AAUBzYWySTAHlUEg2MORFLQDAAxEsEd8FoCuhKfE5ET6yRWXiA2DtAwBjUPA88XVwcT1VUmDq
>aVuQYyLAQSBAK9BQ0SBVLlMuQyswXCdcYTdzEllwVfEtDjEx9yhzLBElUGckQ1vwccADEK90wAmA
>KzAw9G4CEHIAwP8pc27jdlAgIGIBBzF2O3RF/wuAUdEBACoCJGF2YT6jIuX3PrIfEXVRZCQxOKFj
>IHehfnRCoTmhQvEG4CSwKzBJ/0dELzE40kczLBEHgWzQdaD/OmZ7BHlVPMEFIAiQAjAr0P9JUWQz
>Y9I5ETqhBpAIkD+S/y2RZ9EkgAQBQkALgCljK9Dzg0FGoGliRZApggWxBaD8cHlGEn5GPOJw9y7y
>hFLrIEF1Em8sAGImEHWyfVL/gTIsszzBZAAksD+SLBIhgP8AgGSABBB2wwOgBJADYCvB/yVBKdGC
>FG+kESB5cQXAB3D/fLEHMEHRIsA5EQlwRuGLIf9wGIpLKIIhoXbhjVkBACVQ+z9wie9uaIYLA0zw
>AtEgxAs7xBmBAJUQAAAACwABgAggBgAAAAAAwAAAAAAAAEYAAAAAA4UAAAAAAAADAAOACCAGAAAA
>AADAAAAAAAAARgAAAAAQhQAAAAAAAAMAB4AIIAYAAAAAAMAAAAAAAABGAAAAAFKFAAB9bgEAHgAJ
>gAggBgAAAAAAwAAAAAAAAEYAAAAAVIUAAAEAAAAEAAAAOS4wAAsADYAIIAYAAAAAAMAAAAAAAABG
>AAAAAIKFAAABAAAACwA6gAggBgAAAAAAwAAAAAAAAEYAAAAADoUAAAAAAAADADyACCAGAAAAAADA
>AAAAAAAARgAAAAARhQAAAAAAAAMAPYAIIAYAAAAAAMAAAAAAAABGAAAAABiFAAAAAAAACwBSgAgg
>BgAAAAAAwAAAAAAAAEYAAAAABoUAAAAAAAADAFOACCAGAAAAAADAAAAAAAAARgAAAAABhQAAAAAA
>AAIB+A8BAAAAEAAAANcefAzgHMNDvUSTDBatQhYCAfoPAQAAABAAAADXHnwM4BzDQ71EkwwWrUIW
>AgH7DwEAAACZAAAAAAAAADihuxAF5RAaobsIACsqVsIAAFBTVFBSWC5ETEwAAAAAAAAAAE5JVEH5
>v7gBAKoAN9luAAAAQzpcRG9jdW1lbnRzIGFuZCBTZXR0aW5nc1xWOTMzNTIyXExvY2FsIFNldHRp
>bmdzXEFwcGxpY2F0aW9uIERhdGFcTWljcm9zb2Z0XE91dGxvb2tcbWFpbGJveC5wc3QAAAAAAwD+
>DwUAAAADAA00/TcAAAIBfwABAAAAPwAAADxNREVETE5FRUVFQkNHS0tCS0NBS0dFQ0lLTUFELmNh
>dGhlcmluZS5saXR0ZW5AdmFsbGV5cHJlcy5vcmc+AAADAAYQgHMZ5AMABxA3BQAAAwAQEAAAAAAD
>ABEQAQAAAB4ACBABAAAAZQAAAElBTVJBVEhFUlNUQUdOQU5USU5NWVVTRU9GUURFU0lHTi1JVVNV
>QUxMWURFVkVMT1BTSU1QTEVTQ1JFRU5TV0lUSExJVFRMRU1PUkVUSEFOUkVERUZJTkVTT0ZEQVRB
>QU5EREEAAAAA16Y=
>
>------=_NextPart_000_0008_01C28000.F2FEDEE0--
>
>
>--__--__--
>
>Message: 3
>From: "Berry, Robert" <Bob.Berry@Cognos.com>
>To: "'powerh-l@lists.swau.edu'" <powerh-l@lists.swau.edu>
>Subject: PowerHouse Pricing Questions
>Date: Wed, 30 Oct 2002 13:09:56 -0500
>boundary="----_=_NextPart_001_01C2803F.8D68DD30"
>
>This message is in MIME format. Since your mail reader does not understand
>this format, some or all of this message may not be legible.
>
>------_=_NextPart_001_01C2803F.8D68DD30
>Content-Type: text/plain;
> charset="iso-8859-1"
>
>To all PowerHouse users. If at any time you feel the need to discuss Cognos
>ADT pricing issues, please feel free to give me a call or send me an email.
>It is my intention to provide each and everyone of our customers with the
>best pricing arrangements available.
>
>I have been with Cognos/PowerHouse for over 14 years and I'm willing to
>address and attempt to correct any concerns you may have.
>
>I appreciate Al Karmens response to earlier posters. I have worked with Al
>in the past and we have come to mutually beneficial agreements every time.
>
>Sincerely,
>
>Bob Berry
>Director Customer Operations
>Phone 781-313-2270
>Fax 781-229-6230
>Email bob.berry@cognos.com
>
>
> _____
>
>
><http://promos.hotbar.com/promos/promodll.dll?RunPromo&El=hotbar%5felement%3
>bst%3b&SG=&RAND=1> Upgrade Your Email - Click here!
>
>This message may contain privileged and/or confidential information. If you
>have received this email in error or are not the intended recipient, you may
>not use, copy, disseminate or distribute it; do not open any attachments,
>delete it immediately from your system and notify the sender promptly by
>email that you have done so. Thank you.
>
>------_=_NextPart_001_01C2803F.8D68DD30
>Content-Type: text/html;
> charset="iso-8859-1"
>Content-Transfer-Encoding: quoted-printable
>
><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
>To all PowerHouse users. If = at any=20 time you feel the need to discuss
>Cognos ADT pricing issues, please = feel free to=20 give me a call or send
>me an email. It is my intention to = provide=20 each and everyone of our
>customers with the best pricing arrangements=20 available.
>
>I have been with = Cognos/PowerHouse for over=20 14 years and I'm willing
>to address and attempt to correct any concerns = you may=20 have.
>
>I appreciate Al Karmens response = to earlier=20 posters. I have worked
>with Al in the past and we have come to = mutually=20 beneficial
>agreements every time.
>
>Sincerely,
>
>Bob Berry
>Director = Customer=20 Operations
>Phone 781-313-2270
>Fax = 781-229-6230=20
>Email bob.berry@cognos.com
>
>
><BR>
>
><P><FONT SIZE=3D2 FACE=3D"Arial">This message may contain privileged =
>and/or confidential information. If you have received this email in =
>error or are not the intended recipient, you may not use, copy, =
>disseminate or distribute it; do not open any attachments, delete it =
>immediately from your system and notify the sender promptly by email =
>that you have done so. Thank you.</FONT></P>
>
>------_=_NextPart_001_01C2803F.8D68DD30--
>
>--__--__--
>
>Message: 4
>From: David Morrison - Corporate <dmorrison@mcbrideelectric.com>
>To: "'catherine.litten@valleypres.org'" <catherine.litten@valleypres.org>,
>Powerhouse List Server <powerh-l@lists.swau.edu>
>Subject: RE: Qdesign - Sorting Question
>Date: Wed, 30 Oct 2002 10:52:02 -0800
>charset="iso-8859-1"
>
>Catherine,
>
>If you just need one new sequence, you could add a new index on the last
>name (+ first name + ID#, maybe) fields.
>
>Is that an option for you?
>
>David Morrison
>McBride Electric
>
> > -----Original Message-----
> > From: Catherine Litten [mailto:catherine.litten@valleypres.org]
> > Sent: Wednesday, October 30, 2002 10:42 AM
> > To: Powerhouse List Server
> > Subject: Qdesign - Sorting Question
> >
> > I am rather stagnant in my use of QDesign - I usually develop simple
> > screens with little more than redefines of data and data population based
> > on user responses. However, this time I have a user that wants a screen
> > that is really much like a report. This is just a find screen that lists
> > who is on suspension (usually less than a screen full) They would like
> > this in alpha order by last name and name is not a key field.
> >
> > Any recommendations on how to show the data sorted the way they like
> > (usually I just tell them they need a quiz report instead of a screen)
> > without changing the structure of the database?
> >
> > Thank you,
> > Catherine
> >
> >
> >
> > *****************************
> > Catherine Litten, Sr. Programmer/Analyst, Valley Presbyterian Hospital
> > 15107 Vanowen Street, Van Nuys, CA 91405 (818)782.6600 x 2140
> > catherine.litten@valleypres.org
> > ********************************
> > The thoughts, comments, and opinions expressed herein are mine. They do
> > not reflect those of my employer, nor anyone else.
> > ********************************
> > This E-mail is covered by the Electronic Communications Privacy Act, 18
> > U.S.C. §§ 2510-2521 and is legally privileged. This information is
> > confidential information and is intended only for the use of the
> > individual or entity named above. If the reader of this message is not the
> > intended recipient, you are hereby notified that any dissemination,
> > distribution or copying of this communication is strictly prohibited. If
> > you have received this transmission in error, please notify the sender
> > immediately by return electronic transmission and then immediately delete
> > this transmission.
> >
> > _________________________________________________
> > Scanned for viruses on 30 Oct 2002 10:44:56
> > No viruses found.
> > Virus scanning by http://erado.com
>
>--__--__--
>
>Message: 5
>From: "Hasse, Christina" <Christina.Hasse@COGNOS.com>
>To: "'catherine.litten@valleypres.org'" <catherine.litten@valleypres.org>
>Cc: "'powerh-l@lists.swau.edu'" <powerh-l@lists.swau.edu>
>Subject: RE: Qdesign - Sorting Question
>Date: Wed, 30 Oct 2002 13:55:25 -0500
>charset="iso-8859-1"
>
>Hi Catherine,
>
>Can you please provide your working environment; system, database, version
>of PH?
>
>Regards,
>
>Christina Hasse
>ADT North American Technical Manager
>COGNOS CORPORATION
>christina.hasse@cognos.com
>425 N. Martingale Road, Suite 600
>Schaumburg, IL 60173
>Office: 847 - 285 - 2905
>Cell: 847 - 612 - 6854
>
>
> > -----Original Message-----
> > From: Catherine Litten [mailto:catherine.litten@valleypres.org]
> > Sent: Wednesday, October 30, 2002 1:42 PM
> > To: Powerhouse List Server
> > Subject: Qdesign - Sorting Question
> >
> > I am rather stagnant in my use of QDesign - I usually develop simple
> > screens with little more than redefines of data and data population based
> > on user responses. However, this time I have a user that wants a screen
> > that is really much like a report. This is just a find screen that lists
> > who is on suspension (usually less than a screen full) They would like
> > this in alpha order by last name and name is not a key field.
> >
> > Any recommendations on how to show the data sorted the way they like
> > (usually I just tell them they need a quiz report instead of a screen)
> > without changing the structure of the database?
> >
> > Thank you,
> > Catherine
> >
> >
> >
> > *****************************
> > Catherine Litten, Sr. Programmer/Analyst, Valley Presbyterian Hospital
> > 15107 Vanowen Street, Van Nuys, CA 91405 (818)782.6600 x 2140
> > catherine.litten@valleypres.org
> > ********************************
> > The thoughts, comments, and opinions expressed herein are mine. They do
> > not reflect those of my employer, nor anyone else.
> > ********************************
> > This E-mail is covered by the Electronic Communications Privacy Act, 18
> > U.S.C. §§ 2510-2521 and is legally privileged. This information is
> > confidential information and is intended only for the use of the
> > individual or entity named above. If the reader of this message is not the
> > intended recipient, you are hereby notified that any dissemination,
> > distribution or copying of this communication is strictly prohibited. If
> > you have received this transmission in error, please notify the sender
> > immediately by return electronic transmission and then immediately delete
> > this transmission.
> >
> >
>This message may contain privileged and/or confidential information. If you
>have received this e-mail in error or are not the intended recipient, you
>may not use, copy, disseminate or distribute it; do not open any
>attachments, delete it immediately from your system and notify the sender
>promptly by e-mail that you have done so. Thank you.
>
>--__--__--
>
>Message: 6
>From: "Johnson, Harold A EDUC:EX" <Harold.A.Johnson@gems1.gov.bc.ca>
>To: "'catherine.litten@valleypres.org'" <catherine.litten@valleypres.org>,
>Powerhouse List Server <powerh-l@lists.swau.edu>
>Subject: RE: Qdesign - Sorting Question
>Date: Wed, 30 Oct 2002 11:08:51 -0800
>charset="iso-8859-1"
>
>Here's a couple of ideas:
>
>1. use the ORDERBY clause of the ACCESS statement for a FILE.
>
>2. produce the list in a report file and display using your local editor
>(read only mode).
>
>cheers!
>
> > -----Original Message-----
> > From: Catherine Litten [mailto:catherine.litten@valleypres.org]
> > Sent: Wednesday, October 30, 2002 10:42 AM
> > To: Powerhouse List Server
> > Subject: Qdesign - Sorting Question
> >
> > I am rather stagnant in my use of QDesign - I usually develop simple
> > screens with little more than redefines of data and data population based
> > on user responses. However, this time I have a user that wants a screen
> > that is really much like a report. This is just a find screen that lists
> > who is on suspension (usually less than a screen full) They would like
> > this in alpha order by last name and name is not a key field.
> >
> > Any recommendations on how to show the data sorted the way they like
> > (usually I just tell them they need a quiz report instead of a screen)
> > without changing the structure of the database?
> >
> > Thank you,
> > Catherine
> >
> >
> >
> > *****************************
> > Catherine Litten, Sr. Programmer/Analyst, Valley Presbyterian Hospital
> > 15107 Vanowen Street, Van Nuys, CA 91405 (818)782.6600 x 2140
> > catherine.litten@valleypres.org
> > ********************************
> > The thoughts, comments, and opinions expressed herein are mine. They do
> > not reflect those of my employer, nor anyone else.
> > ********************************
> > This E-mail is covered by the Electronic Communications Privacy Act, 18
> > U.S.C. §§ 2510-2521 and is legally privileged. This information is
> > confidential information and is intended only for the use of the
> > individual or entity named above. If the reader of this message is not the
> > intended recipient, you are hereby notified that any dissemination,
> > distribution or copying of this communication is strictly prohibited. If
> > you have received this transmission in error, please notify the sender
> > immediately by return electronic transmission and then immediately delete
> > this transmission.
> >
>
>--__--__--
>
>Message: 7
>From: Nancy Tietz <ntietz@MCARE.MED.UMICH.EDU>
>To: "'catherine.litten@valleypres.org'" <catherine.litten@valleypres.org>,
>Powerhouse List Server <powerh-l@lists.swau.edu>
>Subject: RE: Qdesign - Sorting Question
>Date: Wed, 30 Oct 2002 14:11:36 -0500
>charset="iso-8859-1"
>
>I've had success with using Suprtool to sort on an HP3000. Then the Quick
>screen reads in the output file from the sort. The Suprtool manual has a
>section telling you how to run Suprtool from a quick screen.
>I have code if you need it.
>Hope this helps,
>Nancy
>
>
> > -----Original Message-----
> > From: Catherine Litten [mailto:catherine.litten@valleypres.org]
> > Sent: Wednesday, October 30, 2002 1:42 PM
> > To: Powerhouse List Server
> > Subject: Qdesign - Sorting Question
> >
> > I am rather stagnant in my use of QDesign - I usually develop simple
> > screens with little more than redefines of data and data population based
> > on user responses. However, this time I have a user that wants a screen
> > that is really much like a report. This is just a find screen that lists
> > who is on suspension (usually less than a screen full) They would like
> > this in alpha order by last name and name is not a key field.
> >
> > Any recommendations on how to show the data sorted the way they like
> > (usually I just tell them they need a quiz report instead of a screen)
> > without changing the structure of the database?
> >
> > Thank you,
> > Catherine
> >
> >
> >
> > *****************************
> > Catherine Litten, Sr. Programmer/Analyst, Valley Presbyterian Hospital
> > 15107 Vanowen Street, Van Nuys, CA 91405 (818)782.6600 x 2140
> > catherine.litten@valleypres.org
> > ********************************
> > The thoughts, comments, and opinions expressed herein are mine. They do
> > not reflect those of my employer, nor anyone else.
> > ********************************
> > This E-mail is covered by the Electronic Communications Privacy Act, 18
> > U.S.C. §§ 2510-2521 and is legally privileged. This information is
> > confidential information and is intended only for the use of the
> > individual or entity named above. If the reader of this message is not the
> > intended recipient, you are hereby notified that any dissemination,
> > distribution or copying of this communication is strictly prohibited. If
> > you have received this transmission in error, please notify the sender
> > immediately by return electronic transmission and then immediately delete
> > this transmission.
> >
>
>--__--__--
>
>Message: 8
>From: "Whittall, Conrad" <Conrad.Whittall@Cognos.COM>
>To: "'catherine.litten@valleypres.org'" <catherine.litten@valleypres.org>,
>Powerhouse List Server <powerh-l@lists.swau.edu>
>Subject: RE: Qdesign - Sorting Question
>Date: Wed, 30 Oct 2002 14:16:10 -0500
>charset="iso-8859-1"
>
>Hi Catherine,
>
>I'm assuming you're not using a relational database, otherwise you could
>have simply added an ORDERBY clause to the ACCESS statement in your QDESIGN.
>
>So, why not just use a QUIZ report, run on-line (initiated from a QUICK
>screen that the user already has access to), and formatted for the user's
>terminal -- 80 columns by 23/24 lines (depending on your standard screen
>size)? That way you can extract the data from your database, sort it into
>the required order, and format it for display -- even putting sort break
>header/footers and PRINT AT clauses in if you like.
>
>Best regards,
>Conrad
>
>Conrad Whittall
>e-Learning Architect, Global Education Services
>Cognos Incorporated, 3755 Riverside Drive, Ottawa, Ontario, K1G 4K9, Canada
>
> > -----Original Message-----
> > From: Catherine Litten [mailto:catherine.litten@valleypres.org]
> > Sent: Wednesday 30 October 2002 13:42
> > To: Powerhouse List Server
> > Subject: Qdesign - Sorting Question
> >
> > I am rather stagnant in my use of QDesign - I usually develop simple
> > screens with little more than redefines of data and data population based
> > on user responses. However, this time I have a user that wants a screen
> > that is really much like a report. This is just a find screen that lists
> > who is on suspension (usually less than a screen full) They would like
> > this in alpha order by last name and name is not a key field.
> >
> > Any recommendations on how to show the data sorted the way they like
> > (usually I just tell them they need a quiz report instead of a screen)
> > without changing the structure of the database?
> >
> > Thank you,
> > Catherine
> >
> >
> >
> > *****************************
> > Catherine Litten, Sr. Programmer/Analyst, Valley Presbyterian Hospital
> > 15107 Vanowen Street, Van Nuys, CA 91405 (818)782.6600 x 2140
> > catherine.litten@valleypres.org
> > ********************************
> > The thoughts, comments, and opinions expressed herein are mine. They do
> > not reflect those of my employer, nor anyone else.
> > ********************************
> > This E-mail is covered by the Electronic Communications Privacy Act, 18
> > U.S.C. §§ 2510-2521 and is legally privileged. This information is
> > confidential information and is intended only for the use of the
> > individual or entity named above. If the reader of this message is not the
> > intended recipient, you are hereby notified that any dissemination,
> > distribution or copying of this communication is strictly prohibited. If
> > you have received this transmission in error, please notify the sender
> > immediately by return electronic transmission and then immediately delete
> > this transmission.
> >
> >
>This message may contain privileged and/or confidential information. If you
>have received this e-mail in error or are not the intended recipient, you
>may not use, copy, disseminate or distribute it; do not open any
>attachments, delete it immediately from your system and notify the sender
>promptly by e-mail that you have done so. Thank you.
>
>--__--__--
>
>Message: 9
>From: Nancy Tietz <ntietz@MCARE.MED.UMICH.EDU>
>To: "'catherine.litten@valleypres.org'" <catherine.litten@valleypres.org>,
>"'Powerhouse List Server'" <powerh-l@lists.swau.edu>
>Subject: RE: Qdesign - Sorting Question
>Date: Wed, 30 Oct 2002 14:16:47 -0500
>charset="iso-8859-1"
>
>Also, it isn't hard to run a Quiz from your Quick screen and actually show a
>Quiz report online if the population is small.
>I have code if you need it.
>Nancy
>
> > -----Original Message-----
> > From: Nancy Tietz
> > Sent: Wednesday, October 30, 2002 2:12 PM
> > To: 'catherine.litten@valleypres.org'; Powerhouse List Server
> > Subject: RE: Qdesign - Sorting Question
> >
> > I've had success with using Suprtool to sort on an HP3000. Then the Quick
> > screen reads in the output file from the sort. The Suprtool manual has a
> > section telling you how to run Suprtool from a quick screen.
> > I have code if you need it.
> > Hope this helps,
> > Nancy
> >
> >
> > -----Original Message-----
> > From: Catherine Litten [mailto:catherine.litten@valleypres.org]
> > Sent: Wednesday, October 30, 2002 1:42 PM
> > To: Powerhouse List Server
> > Subject: Qdesign - Sorting Question
> >
> > I am rather stagnant in my use of QDesign - I usually develop simple
> > screens with little more than redefines of data and data population based
> > on user responses. However, this time I have a user that wants a screen
> > that is really much like a report. This is just a find screen that lists
> > who is on suspension (usually less than a screen full) They would like
> > this in alpha order by last name and name is not a key field.
> >
> > Any recommendations on how to show the data sorted the way they like
> > (usually I just tell them they need a quiz report instead of a screen)
> > without changing the structure of the database?
> >
> > Thank you,
> > Catherine
> >
> >
> >
> > *****************************
> > Catherine Litten, Sr. Programmer/Analyst, Valley Presbyterian
> > Hospital
> > 15107 Vanowen Street, Van Nuys, CA 91405 (818)782.6600 x 2140
> > catherine.litten@valleypres.org
> > ********************************
> > The thoughts, comments, and opinions expressed herein are mine.
> > They do not reflect those of my employer, nor anyone else.
> > ********************************
> > This E-mail is covered by the Electronic Communications Privacy Act,
> > 18 U.S.C. §§ 2510-2521 and is legally privileged. This information is
> > confidential information and is intended only for the use of the
> > individual or entity named above. If the reader of this message is not the
> > intended recipient, you are hereby notified that any dissemination,
> > distribution or copying of this communication is strictly prohibited. If
> > you have received this transmission in error, please notify the sender
> > immediately by return electronic transmission and then immediately delete
> > this transmission.
> >
>
>
>
>--__--__--
>
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l@lists.swau.edu
>Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
>Unsubscribe: "unsubscribe <password>" in message body to
>powerh-l-request@lists.swau.edu
>http://lists.swau.edu/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.
>
>
>End of powerh-l Digest
____________________________
Terry Pickering