Re: RE: RE: [sqr-users] array printing challenge

["PeterG Clark" <PeterG.Clark@vac-acc.gc.ca>]

Are you sure? I ran tests and it wrapped on every '|'. Perhaps it works 
differently on different versions of SQR.

>>> steve.cavill@infoclarity.com.au 2006/01/19 19:07:50 >>>
Note this is just like wrapping on spaces, it will only wrap when it needs
to, not on every '|'.
Steve.


> Have a look at the on= option of wrap
> e.g.
> print $instr_name (,+1) wrap 80 2 on='|'  !Note this will not print the
last
> | on the line.
> Steve.
> ----- Original Message -----
> From: "Anya Mendenhall" <agueniss@gwu.edu>
> To: "This list is for discussion about the SQR database reportinglanguage
> from Hyperion Solutions." <sqr-users@sqrug.org>
> Sent: Thursday, January 19, 2006 8:19 AM
> Subject: Re: RE: RE: [sqr-users] array printing challenge
>
>
> > yep. that is why I asked the question..Not sure about the logic ..
> >
> > ********************************************
> >   Anya Mendenhall
> >   Enterprise Resource Planning Developer
> >   Information Systems & Services'
> >   The George Washington University
> >   44983 Knoll Square, Ste 380,
> >   Ashburn, Virginia 20147
> >   Tel No: 703-726-1970
> >   Fax No: 202-994-5251
> > ********************************************
> >
> >
> > ----- Original Message -----
> > From: "Knapp, Richard" <KnappR@umsystem.edu>
> > Date: Wednesday, January 18, 2006 4:10 pm
> > Subject: RE: RE: [sqr-users] array printing challenge
> > To:  "This list is for discussion about the SQR database
> > reportinglanguage from Hyperion Solutions." <sqr-users@sqrug.org>
> >
> > >
> > > But all the names can't print on the same line.  So you are going to
> > > have to count characters and construct some logic to handle the
> > > printing.
> > >
> > > Richard Knapp
> > > Database Programmer/Analyst
> > > Institutional Research and Planning
> > > University of Missouri System
> > > 573-882-8856
> > > knappr@umsystem.edu 
> > >
> > > -----Original Message-----
> > > From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org 
> > > [mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of
> > > Anya Mendenhall
> > > Sent: Wednesday, January 18, 2006 2:34 PM
> > > To: This list is for discussion about the SQR database
> > > reportinglanguagefrom Hyperion Solutions.
> > > Subject: Re: RE: [sqr-users] array printing challenge
> > >
> > > I guess I was not very clear. I want all of the names to print on
> > > the
> > > same line. However, when the printing gets to a name and it is the
> > > end
> > > of the line, I need this name to be printed on the next line. So
> > > if I
> > > have my array as follows:
> > >
> > >
> > >    Gallo|Y| Sarrafzdeh| Medghalchi| Swan| Shibata| Daryabandari|
> > > Turkkan| Almarmoom| Liebes| Alhussaini| Bushkrs
> > > kilo| Bob|
> > >
> > > I need Bushkrskilo| to be printed on the new line, so that it
> > > looks
> > > like this:
> > >
> > > Gallo|Y| Sarrafzdeh| Medghalchi| Swan| Shibata| Daryabandari|
> > > Turkkan|
> > > Almarmoom| Liebes| Alhussaini|
> > > Bushkrskilo| Bob|
> > >
> > >
> > >
> > >
> > > ********************************************
> > >  Anya Mendenhall
> > >  Enterprise Resource Planning Developer
> > >  Information Systems & Services
> > >  The George Washington University
> > >  44983 Knoll Square, Ste 380,
> > >  Ashburn, Virginia 20147
> > >  Tel No: 703-726-1970
> > >  Fax No: 202-994-5251
> > > ********************************************
> > >
> > >
> > > ----- Original Message -----
> > > From: bmrazek@sympatico.ca 
> > > Date: Wednesday, January 18, 2006 3:30 pm
> > > Subject: Re: RE: [sqr-users] array printing challenge
> > > To:  "This list is for discussion about the SQR database reporting
> > > language from Hyperion Solutions." <sqr-users@sqrug.org>
> > >
> > > > Removing the comman fixed your wrap error.  All your names are
> > > > printing on the same line because you are not increasing your
> > > line
> > > > positon in the print command.
> > > >
> > > > Example: print &name (+1, 20) bold
> > > >
> > > > +1 says print on the next line, 20 is the column position to
> > > start
> > > > the print.
> > > >
> > > >
> > > > >
> > > > > From: Anya Mendenhall <agueniss@gwu.edu>
> > > > > Date: 2006/01/18 Wed PM 03:12:43 EST
> > > > > To: "This list is for discussion about the SQR database reporting
> > > > > language from Hyperion Solutions." <sqr-users@sqrug.org>
> > > > > Subject: Re: RE: [sqr-users] array printing challenge
> > > > >
> > > > > comma is removed, names still wrap..
> > > > >
> > > > > ********************************************
> > > > >   Anya Mendenhall
> > > > >   Enterprise Resource Planning Developer
> > > > >   Information Systems & Services
> > > > >   The George Washington University
> > > > >   44983 Knoll Square, Ste 380,
> > > > >   Ashburn, Virginia 20147
> > > > >   Tel No: 703-726-1970
> > > > >   Fax No: 202-994-5251
> > > > > ********************************************
> > > > >
> > > > >
> > > > > ----- Original Message -----
> > > > > From: Peter Burton <Peter_Burton@hyperion.com>
> > > > > Date: Wednesday, January 18, 2006 3:11 pm
> > > > > Subject: RE: [sqr-users] array printing challenge
> > > > > To:  "This list is for discussion about the SQR database
> > > > > reportinglanguage from Hyperion Solutions." <sqr-
> > > users@sqrug.org>
> > > > >
> > > > > >
> > > > > > SQR is issuing the error because you have a comma after the
> > > > 80.
> > > > > > Removethe comma.
> > > > > >
> > > > > > Peter
> > > > > >
> > > > > > -----Original Message-----
> > > > > > From: sqr-users-bounces+peter_burton=hyperion.com@sqrug.org 
> > > > > > [mailto:sqr-users-
> > > bounces+peter_burton=hyperion.com@sqrug.org] 
> > > > On
> > > > > > BehalfOf Knapp, Richard
> > > > > > Sent: Wednesday, January 18, 2006 3:00 PM
> > > > > > To: This list is for discussion about the SQR database
> > > > > > reportinglanguagefromHyperion Solutions.
> > > > > > Subject: RE: [sqr-users] array printing challenge
> > > > > >
> > > > > >
> > > > > > I think this is a print challenge rather than an array
> > > > challenge.
> > > > > > Whatrow(s) do you imagine these array elements are being
> > > > printed on?
> > > > > >
> > > > > > Richard Knapp
> > > > > > Database Programmer/Analyst
> > > > > > Institutional Research and Planning
> > > > > > University of Missouri System
> > > > > > 573-882-8856
> > > > > > knappr@umsystem.edu 
> > > > > >
> > > > > > -----Original Message-----
> > > > > > From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org 
> > > > > > [mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On
> > > > Behalf Of
> > > > > > Anya Mendenhall
> > > > > > Sent: Wednesday, January 18, 2006 1:45 PM
> > > > > > To: sqr-users@sqrug.org 
> > > > > > Subject: [sqr-users] array printing challenge
> > > > > >
> > > > > >
> > > > > > Array challenge
> > > > > >
> > > > > > Ok, I am not sure if this is possible in SQR. I have an
> > > array
> > > > of
> > > > > > students that can store up to 16 names. I have defined my
> > > > array as
> > > > > > follows:
> > > > > >
> > > > > > create-array name=instr_arr size=100  field=last_name:char
> > > > > >
> > > > > > When I put values into my array, I actually concatenate
> > > > students
> > > > > > name
> > > > > > along with a | and a certain indicator. So a value in my
> > > array
> > > > > > might
> > > > > > look like this:
> > > > > >
> > > > > > Liang|Y|
> > > > > > Jenn Doe|Y| Anna Smith|Y
> > > > > > Todd Bond|Y| Joe Shmoe|
> > > > > >
> > > > > > The problem is that when I print out this array and the
> > > array
> > > > has
> > > > > > a lot
> > > > > > of names in it, the names wrap so that one part of the name
> > > is
> > > > on
> > > > > > one
> > > > > > line and the other part of the name is on the other line.
> > > Here
> > > > is
> > > > > > an
> > > > > > example:
> > > > > >
> > > > > >                   Gallo|Y| Sarrafzdeh| Medghalchi| Swan|
> > > > Shibata|
> > > > > > Daryabandari| Turkkan| Almarmoom| Liebes| Alhussaini| Bush|
> > > Vande> > > rhoek| Almidfa| Khan| Ahmadi-Sabet|
> > > > > >
> > > > > > Do you see  how Vanderhoek wraps around? How do I go about
> > > it?
> > > > I
> > > > > > need
> > > > > > to figure out if I am at the end of the line and go to the
> > > > next? I
> > > > > > tried the wrap command, but it does not work, as I get the
> > > > > > following
> > > > > > error:
> > > > > >
> > > > > > Error on line 287:
> > > > > >   (SQR 5304) Qualifier 'wrap' requires a numeric literal,
> > > > > > variable, or
> > > > > > column.
> > > > > >      print $instr_name (,+1) wrap 80, 2
> > > > > >
> > > > > > Here is my code:
> > > > > >
> > > > > > while #ind < {maxArraySize}
> > > > > >    let $instr_name = instr_arr.last_name(#ind)
> > > > > >
> > > > > >    if ($flag = 'N')
> > > > > >      print $instr_name (,4,15)
> > > > > >    else
> > > > > >      print $instr_name (,+1) wrap 80, 2 - this wrap command
> > > > does
> > > > > > not
> > > > > > work
> > > > > >    end-if
> > > > > >
> > > > > >    let $flag = 'Y'
> > > > > >    add 1 to #ind
> > > > > >
> > > > > >  end-while
> > > > > >
> > > > > >
> > > > > > Any ideas on how to go about this? Thank you!
> > > > > > ********************************************
> > > > > >  Anya Mendenhall
> > > > > >  Enterprise Resource Planning Developer
> > > > > >  Information Systems & Services
> > > > > >  The George Washington University
> > > > > >  44983 Knoll Square, Ste 380,
> > > > > >  Ashburn, Virginia 20147
> > > > > >  Tel No: 703-726-1970
> > > > > >  Fax No: 202-994-5251
> > > > > > ********************************************
> > > > > >
> > > > > >
> > > > > > _______________________________________________
> > > > > > sqr-users mailing list
> > > > > > sqr-users@sqrug.org 
> > > > > > http://www.sqrug.org/mailman/listinfo/sqr-users 
> > > > > >
> > > > > >
> > > > > >
> > > > > > _______________________________________________
> > > > > > sqr-users mailing list
> > > > > > sqr-users@sqrug.org 
> > > > > > http://www.sqrug.org/mailman/listinfo/sqr-users 
> > > > > >
> > > > >
> > > > >
> > > >
> > >
> > > _______________________________________________
> > > sqr-users mailing list
> > > sqr-users@sqrug.org 
> > > http://www.sqrug.org/mailman/listinfo/sqr-users 
> > >
> >
>
>
> --------------------------------------------------------------------------
--
> ----
>
>
> > Here was a non admissible message part of 'text/x-vcard' MIME type. It
> > has been automatically discarded before sending the message to the
> > list.
> >
>
>
> --------------------------------------------------------------------------
--
> ----
>
>
> > _______________________________________________
> > sqr-users mailing list
> > sqr-users@sqrug.org 
> > http://www.sqrug.org/mailman/listinfo/sqr-users 
> >
>



_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org 
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users