subfile name

Tue, 12 Oct 2004 15:16:36 -0400

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C4B08F.FE5239B0
Content-Type: text/plain

Hi Viet,

I assume that the source is interactive QUIZ and not compiled. I believe
that compiled QUIZ does not give the option for a variable filename. You
can generate a separate source line that states "set subfile name <variable>
keep" and then call that line using a "USE" statement.

Set report limit 1
Access XXX
Define month char*2 = cconvert(sysdate){5:2}
Define text_line char*80 = "set subfile name SAVE" + month
Report summary text_line
Set subfile name subline 
Go

Set report nolimit
Access ....
Report ..
Use subline
Go

Hope that helps.

Daniel Mielke
AIC Limited

-----Original Message-----
From: Viet Nguyen [mailto:VNguyen@wsboces.org] 
Sent: October 12, 2004 2:41 PM
To: powerh-l@lists.sowder.com
Subject: subfile name

Hi All,
   How do I set subfile name based on a variable
   For Example: Every Month we run a report and I want to save data to a
file name with the month as part of the file name i.e SAVE01, SAVE02,
SAV03 etc... Let's say the variable is xMonth - values 01,02,03...etc...
Thanks in advance.
Viet.

t be a subscriber.

------_=_NextPart_001_01C4B08F.FE5239B0
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2654.45">
<TITLE>RE: subfile name</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=3D2>Hi Viet,</FONT>
</P>

<P><FONT SIZE=3D2>I assume that the source is interactive QUIZ and not =
compiled.&nbsp; I believe that compiled QUIZ does not give the option =
for a variable filename.&nbsp; You can generate a separate source line =
that states &quot;set subfile name &lt;variable&gt; keep&quot; and then =
call that line using a &quot;USE&quot; statement.</FONT></P>

<P><FONT SIZE=3D2>Set report limit 1</FONT>
<BR><FONT SIZE=3D2>Access XXX</FONT>
<BR><FONT SIZE=3D2>Define month char*2 =3D =
cconvert(sysdate){5:2}</FONT>
<BR><FONT SIZE=3D2>Define text_line char*80 =3D &quot;set subfile name =
SAVE&quot; + month</FONT>
<BR><FONT SIZE=3D2>Report summary text_line</FONT>
<BR><FONT SIZE=3D2>Set subfile name subline </FONT>
<BR><FONT SIZE=3D2>Go</FONT>
<BR><FONT SIZE=3D2>&nbsp;</FONT>
<BR><FONT SIZE=3D2>Set report nolimit</FONT>
<BR><FONT SIZE=3D2>Access ....</FONT>
<BR><FONT SIZE=3D2>Report ..</FONT>
<BR><FONT SIZE=3D2>Use subline</FONT>
<BR><FONT SIZE=3D2>Go</FONT>
</P>

<P><FONT SIZE=3D2>Hope that helps.</FONT>
</P>

<P><FONT SIZE=3D2>Daniel Mielke</FONT>
<BR><FONT SIZE=3D2>AIC Limited</FONT>
</P>

<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Viet Nguyen [<A =
HREF=3D"mailto:VNguyen@wsboces.org">mailto:VNguyen@wsboces.org</A>] =
</FONT>
<BR><FONT SIZE=3D2>Sent: October 12, 2004 2:41 PM</FONT>
<BR><FONT SIZE=3D2>To: powerh-l@lists.sowder.com</FONT>
<BR><FONT SIZE=3D2>Subject: subfile name</FONT>
</P>

Hi All,
 &nbsp;&nbsp; How do I set subfile name based on a =
variable
 &nbsp;&nbsp; For Example: Every Month we run a =
report and I want to save data to a
 file name with the month as part of the file name =
i.e SAVE01, SAVE02,
 SAV03 etc... Let's say the variable is xMonth - =
values 01,02,03...etc...
 Thanks in advance.
 Viet.

<P><FONT SIZE=3D2>t be a subscriber.</FONT>
</P>

</BODY>
</HTML>
------_=_NextPart_001_01C4B08F.FE5239B0--