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

["White . Denise" <DWhite@drc.com>]

LOL - to me, that looks like overkill.  I would just write them as three
separate lines.  Very straightforward.

Denise M. White
EBS Programmer/Analyst III
Dynamics Research Corporation
------------------------------

Message: 12
Date: Tue, 14 Nov 2006 17:10:12 -0600
From: "Bob Stone" <bstone@fastenal.com>
Subject: RE: [sqr-users] Writing values in separate lines
To: "This list is for discussion about the SQR database reporting
        language        from Hyperion Solutions." <sqr-users@sqrug.org>
Message-ID: <E8629566E0BAC048A35B31BC78AF4C4805F1103E@excmb01.backup>
Content-Type: text/plain;       charset="us-ascii"

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