David:
The problem is the sequence is incorrect. You created the variables, concatenated the 
results then did the calculation.  Move the concatenation part to come after the 
calculation.

To follow one variable thru (Line numbers on the left):

8   SET VAR vtcase1st INTEGER
9   SET VAR vtcase1sttxt TEXT
23  set var vtcase1sttxt = (CTXT(.vtcase1st))
33  SET VAR vtxt1st TEXT
40  SET VAR vtxt1st = 'cases open 1st of the month = ' + .vtcase1sttxt
65  SELECT case1st INTO vtcase1st INDICATOR vtind1 FROM vutemp1
123 WRITE .vtxt1st

If I may comment. You may simplify by combining actions:

SELECT case1st INTO vtcase1st INDICATOR vtind1 FROM vutemp1
WRITE 'cases open 1st of the month =', .vtcase1st

Selecting into variables will create them and type them the same as the data field.

Hope this helps,

Jim Blackburn
Kodiak

David Ebert wrote:
> 
> I'm trying to create a command file that outputs values to a file.  It works
> in trace, but not from the command line.  I'm doing something wrong, but can
> t figure out what.
> 
> What I get is this:
> 
> Monthly program case stats
> 
> 
> 
> 02/01/2002  to  02/28/2002
> 
> =============================================
> 
> 
> 
> cases open 1st of the month =
> 
> 
> 
> number of new cases opened =
> 
> 
> 
> number of cases closed =
> 
> 
> 
> cases open end of the month =
> 
> 
> 
> number of youth receiving service =
> 
> 
> 
> In Trace the values appear. The code is attached (since my mail client can't
> take cut/paste and produce plain text).
> 
> tia for any help.
> 
> Dave
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/

Reply via email to