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

["Bob Stone" <bstone@fastenal.com>]

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