James

Here's my quickie test of what I think you want. It's 8.19 but I don't think
that should make a difference. Note that I made the size of the subfile in
the first request bigger than the input limit. Let me know if 7.29 really
doesn't work!

Regards,
JWP

/qtp

Q T P   (PowerHouse  8.19.C4)
Copyright 1999 COGNOS INCORPORATED
Norbord Industries Inc.

> use qeditscr
> req one
> acc transactions
> tem t-one zon*5
> ite t-one = 416
> sub sf1 size 100 inc t-one
> set inp lim 10
> req two
> acc *sf1
> tem t-one zon*5
> ite t-one count
> sub sf1 ali sf1-1 at final append inc t-one
> go

Executing request ONE ...
*W* Input limit has been exceeded.

Records read:
  TRANSACTIONS                            11

Transactions processed:                   10

Records processed:                     Added    Updated  Unchanged
Deleted
  SF1                                     10          0          0
0


Executing request TWO ...

Records read:
  SF1                                     10

Transactions processed:                   10

Records processed:                     Added    Updated  Unchanged
Deleted
  SF1-1                                    1          0          0
0

Finished.
> e
End Run
/l sf1
    1     00416
    2     00416
    3     00416
    4     00416
    5     00416
    6     00416
    7     00416
    8     00416
    9     00416
   10     00416
   11     00010
/

> -----Original Message-----
> From: James B. Byrne [SMTP:[log in to unmask]]
> Sent: Tuesday, November 28, 2000 2:51 PM
> To:   [log in to unmask]
> Subject:      Cognos QTP question
>
> I sent a request to the Powerhouse list earlier and haven't had
> any reply so I thought that I would cast my net a little wider.
>
> I am trying to do something which I believe I have done many
> times before.  However it isn't working and I must be
> overlooking something obvious.
>
> Running QTP7.29C8 I wish to open a new subfile in request1,
> destroying any existing subfile.  I then wish to add some
> records.  This part works.  I would be somewhat abashed if I
> couldn't get this part to work!
>
> Now, in request2 of the same run I want to count the number
> of records in the above mentioned subfile and append a record
> containing the count to that subfile.  This I can't get to work.  I
> have gone at this two ways.
>
> First with:
>
> ACCESS *X
> TEMP TCOUNT
> ITEM TCOUNT INITIAL 1 COUNT
> SUBFILE X ALIAS AS Y APPEND AT FINAL &
>         INCLUDE TCOUNT
>
> Next with:
> ACCESS *X
> TEMP TCOUNT
> OUTPUT *X ALIAS AS Y ADD AT FINAL
>         ITEM TCOUNT INITIAL 1 COUNT
>
> Neither of these will append any record to the subfile
> previously created.  If I subfile to a new subfile with the KEEP
> option then both the file and the record are created with the
> correct information.  If I subfile or output to the existing file
> declared in the access statement then no record shows up in
> the file.
>
> The program complies without error, and runs without error in
> all of the afore-mentioned cases.  In all cases request2 reports
> that it added 1 record. However when I open the file to view the
> records there are only those created in request1.  To simplify
> matters I am only writing out one record in request1.
>
> What am I overlooking?
>
> Regards,
> Jim
> ---   *** e-mail is not a secure channel ***
> James B. Byrne                Harte & Lyne Limited
> vox: +1 905 561 1241          9 Brockley Drive
> fax: +1 905 561 0757          Hamilton, Ontario
> mailto:[log in to unmask]  Canada L8E 3C3