[Bulk] Use of TEMPS and their resetting

[Ken Langendock]

Sorry, didn't see that you had tried that already.

 

Maybe include a sample of the code (stripped down) so we can see what you
are trying to do.

 

Ken

 

From: powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com
[mailto:powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com] On
Behalf Of John Stires
Sent: May 27, 2009 7:33 AM
To: powerh-l at lists.sowder.com
Subject: [Bulk] Use of TEMPS and their resetting

 

I am working on a screen that accesses only one file.  It is indexed, but I
am not using any of the indexes, essentially using it as a sequential file.
The records are pre-populated with some data, my screen will allow the user
to input a Check Number, Transit Number and an AMT PD amount only.  When the
records come in, the Check Number and Transit Number fields are both blank.
Because there are a number of members paid on one check, I have a header
that contains the Check Number and Transit Number.  Then there is a cluster
with one line per member.  The user will enter the Check Number and Transit
Number once, in the header, and then just go down through the members
entering only the AMT PD.  There is a Last Date Update field that
automatically gets SYSDATE.

 

My problem is that the TEMP I am using for the Check Number and Transit
Number in the header gets reset before it moves to the second update record.
At best, only the first record gets the Check Number and Transit Number and
all other fields get updated correctly on the only the first record.  After
the first record, all fields are correctly updated correctly EXCEPT the
Check Number and Transit Number, which come out blank.

 

I suspect there is a timing issue the TEMPS for the Check Number and Transit
Number plaguing me here, but, for the life of me, I am missing some
something.  I have tried using RESET AT STARTUP and AT MODE.  I have tried
using an OCCURS WITH, OCCURS n TIMES, with NO OCCURS, and with and without a
SELECT for Check Number and Transit Number to be blank and with the SELECT
for the Check Number and Transit Number to equal the TEMPS.

 

I need a little guidance on these TEMPS and their resetting.  I am fast
running out of ideas.

 

We are using version 8.40 D1 on an OpenVMS V7.3-1.

 

Thanks for any help you al can offer me.

 

Thanks,

John

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20090527/e4483b5d/attachment.htm