RE: [sqr-users] Writing values in separate lines

["Jamie Harris" <JHarris@frederick.edu>]

Nothing at all.  That's the right way. :)

-----------------------------------------------------
James Harris
Enterprise Application Analyst/Programmer
Information Technology Division
Frederick Community College 

-----------------------------------------------------

>>> <Roger.Harris@certegy.com> 11/15/2006 12:41 PM >>>
Ok, maybe I am overlooking something here, but what would be wrong
with
just doing it like this:

begin-select
emplid
tax
grss

    write #fileNum from &emplid
    write #fileNum from &tax
    write #fileNum from &grss

from ps_test
end-select

Presto! Each value on a separate line and no encoding or stringing.


Roger L. Harris
Programmer Analyst Sr
Product Development
Certegy Check Services
Fidelity National Information Services, Inc
11601 N. Roosevelt Blvd
St Petersburg, FL 33716

(727) 227-5850 direct
(800) 215-6280 x75850 toll free
(727) 570-4917  Fax



|---------+---------------------------------------------------->
|         |           "Dwight Schrute"                         |
|         |           <schrute.dwight@hotmail.com>             |
|         |           Sent by:                                 |
|         |           sqr-users-bounces+roger.harris=certegy.co|
|         |           m@sqrug.org                              |
|         |                                                    |
|         |                                                    |
|         |           11/15/2006 11:19 AM                      |
|         |           Please respond to "This list is for      |
|         |           discussion about the SQR database        |
|         |           reporting language from Hyperion         |
|         |           Solutions."                              |
|---------+---------------------------------------------------->
 
>---------------------------------------------------------------------------------------------|
  |                                                                    
                        |
  |       To:       sqr-users@sqrug.org                                
                        |
  |       cc:                                                          
                        |
  |       Subject:  RE: [sqr-users] Writing values in separate lines   
                        |
 
>---------------------------------------------------------------------------------------------|




Instead of using the "let" commands, try using "string".  Building
upon
Bob's response, it would be:

   string &emp &tax &gss by $crlf into $var_to_write_as_rows
   write 10 from $var_to_write_as_rows

This is more concise and doesn't require the extra variables.  In
addition,

performance is increase since "let" is so slow.

AND CLARK, DON'T BE SUCH AN ASS!!


>From: "Bob Stone" <bstone@fastenal.com>
>Reply-To: "This list is for discussion about the SQR database
>reportinglanguage from Hyperion Solutions." <sqr-users@sqrug.org>
>To: "This list is for discussion about the SQR database reporting
>languagefrom Hyperion Solutions." <sqr-users@sqrug.org>
>Subject: RE: [sqr-users] Writing values in separate lines
>Date: Tue, 14 Nov 2006 17:10:12 -0600
>
>lol.  Suppose he wanted an actual response?
>
>Why not just pretend you're hitting the enter key between each
variable?
>I prefer to do that with a $cr variable set to the ascii of
>'carraige-return' (note that if your file is Windows you probably
need
>to append 'line-feed' which is ascii 10).
>
>
>  ENCODE <13> INTO $CR
>
>(or)
>
>  ENCODE <13> into $cr
>  ENCODE <10> into $lf
>  let $crlf = $cr || $lf
>
>
>begin-select
>emplid
>tax
>grss
>   let $emp = &emplid
>   let $tax = &tax
>   let $grss = &grss
>
>   let $var_to_write_as_rows = $emp || $cr || $tax || $cr || grss ||
$cr
>
>   write 10 from $var_to_write_as_rows
>from ps_test
>end-select
>
>
>
>-----Original Message-----
>From: sqr-users-bounces+bstone=fastenal.com@sqrug.org
[mailto:sqr-users-
>
>Why yes, it is....
>
>peace,
>clark 'the dragon' willis
>
>----Original Message Follows----
>
>Hi,
>     Is it possible to write 4 column values as 4 separate rows to a
text
>
>file in SQR? For eg. if i use
>            begin-select
>            emplid
>            tax
>            grss
>                        write-file
>                        !instead of writing 3 values as one row, i
need to
write
>it as 3 different
>rows, some thing like this
>                        !emplid
>                        !tax
>                        !grss
>            from ps_test
>
>Thanks
>RK
>
>_______________________________________________
>sqr-users mailing list
>sqr-users@sqrug.org 
>http://www.sqrug.org/mailman/listinfo/sqr-users 

_________________________________________________________________
Get today's hot entertainment gossip
http://movies.msn.com/movies/hotgossip?icid=T002MSN03A07001 


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





------------------------------------------------------------------------------
This message contains information from Certegy, Inc which may be
confidential and privileged.  If you are not an intended recipient,
please refrain from any disclosure, copying, distribution or use of this
information and note that such actions are prohibited.  If you have
received this transmission in error, please notify by e:mail
postmaster@certegy.com.
==============================================================================


_______________________________________________
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