Re: Actively Insert New Record Into Subfile.

Thanks for the reply. Instead of using an Array, I used a QTEMP file. I
do expect less than 100 records in the subfile. This is dealing with
returned merchandise. I would imagine that most of the time it'll be less
than 10.

So far it's working nicely. The only problem, the prompt program I'm
trying to use will not allow me to position it where I want it, it only
wants to go to the position of the cursor. This is fine if I wasn't on a
RF gun. LOL. I'll have to duplicate the code and make my own prompt for
the RF.

On Wed, Mar 28, 2012 at 2:46 PM, Booth Martin <booth@xxxxxxxxxxxx> wrote:

The details subfile will no doubt be under 100 items?

In that event, it might make sense to first fill an array with the data,
and then fill the subfile from the array.

Then create a exfmt loop where the subfile is read, compared to the
array itself, and a new array made from the new data, including any
provisions you want to make for added returns, or whatever. Then, copy
the new array to the original array and totally reload the subfile with
the new information. It will run very quickly; certainly sub-second.



On 3/28/2012 1:36 PM, Michael Schutte wrote:

I was wondering if anyone has attempted to actively insert new records

into

a subfile? What I'm trying to accomplish is when a customer returns an
item, I want them the company to supply a reason code for the return.

Now

the customer could have ordered two of the same item and returned both of
them for two different reasons. I figured, I would first bring up the
order, have the company select the quantity being returned, then on the
next screen, list all of the items they selected, giving them the ability
to enter a reason code and the quantity being returned for that reason.

If

they enter a quantity that is less than what was selected on the first
screen then I want to pop in a new subfile record below it so that they

can

enter another reason code. Does that make sense?

So on the first screen, the user will enter in a 1 to select the item and
then be taken to another screen.

Option:1=Select

O Item Qty
*1* 69374 * 3*
*1* 69375 * 2*
*
*
*
*
Item Qty Reason
69374 * 3* * *
69375 * 2* _____
*
*
*
*
Lets say that item 69374, the company puts a 1 in the Qty column. When
they leave the field, I would like to add a new record to the subfile

right

below it. So that it would look like.

Item Qty Reason
69374 * 1* * *
69374 * 2* * *
69375 * 2* _____


I have my thoughts... I'd imagine that there is a DDS keyword that will
trigger the return back to the program and then I'll need to reload the
subfile adding the new record when needed. But I would need to save the
relative record number so that the cursor is returned back to where the
user was at. When returning back to the program, I could insert records
into a qtemp file of what the user entered, compare the quantity to what
the user originally entered. If it doesn't match, then insert a new

record

to the qtemp file with the remainder. Then reload the subfile with the
qtemp file.

I envision this being a LOAD ALL Subfile.

Any suggestions. Tried googling but didn't really find anything

relevant.

If my screen layouts didn't come across correctly, copy it to notepad

with

font being courier new.

Thank you,
Michael Schutte

--
Booth Martin
802-461-5349
http://www.martinvt.com
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.