Re: prob in deleting records using a subfile from a pf. -- MIDRANGE-L

Michael,

You are correct, of course, about the READ opcode not working againstsubfiles; at least I never got it to work.

Instead of requiring the user to type a '4' (or whatever), a couple ofalternatives leap to mind:


   * Delete the records on the same basis as the subfile was built, or
   * Keep a temporary file of the contents of the subfile (in, say, QTEMP).

Sunny did not indicate how many records there are potentially. The usermight get P-Oed at the '4' option if he's talking large number of records.



        * Jerry C. Adams
*IBM System i Programmer/Analyst
B&W Wholesale Distributors, Inc.* *
voice
        615.995.7024
fax
        615.995.1201
email
        jerry@xxxxxxxxxxxxxxx <mailto:jerry@xxxxxxxxxxxxxxx>



Michael_Schutte@xxxxxxxxxxxx wrote:

Create an option field for the user to enter into.  Say '4'.  Then use the
READC or design a loop that will  CHAIN to each subfile record to retrieve
value.  Then for each record that has a '4', pop up a window to ask the
user if their sure they want to delete this record.  Press F11 to delete.
etc...

READP READ cannot be used on Subfiles. Don't have the exact answer why but
you can probably find it with some research.

Michael Schutte

sunny singh<franky_four_fingures@xxxxxxxxx> ToSent by: MIDRANGE-L@xxxxxxxxxxxxmidrange-l-bounce ccs@xxxxxxxxxxxxSubjectprob in deleting records using a05/01/2006 10:38 subfile from a pf.AMPlease respond toMidrange SystemsTechnicalDiscussion<midrange-l@midrange.com>




hi all..
             i have a   prob  regarding subfiles..
 i have a load all subfile displaying  for example four selected records
by the user.
 now i want all the records to be deleted when the user presses certain
key say f11.
 i am having a prob   when i tried to do this by reading the subfile
record format from the top and then chaining to the physical file in a
loop..can any one plz explain the proceedure for just idea of how this
could be done
 example...
 date                                       xyz bank
time

  number                              name
dept                  salary
 101                                     john
comp                 12344
 102                                     franky
mba                   38474
 103                                     rocky
comp                 123454
 104                                     nick
b.tech                 345676

 how can we delete above all four records that has been displayed on the
above screen.niumber beeing key field.
 why cant i perform readp or reads operation on this subfile.
 thanks in advance...
 please do reply.
 have a nice day........






---------------------------------
Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls.  Great rates
starting at 1&cent;/min.
--
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.