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

["Dwight Schrute" <schrute.dwight@hotmail.com>]

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