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

ok..  thanks jerry and michael
  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).
this is what i was thinking of and want to learn .. using q temp probably will 
help me in future,
  thanks again
  

Jerry Adams <jerry@xxxxxxxxxxxxxxx> wrote:
  Michael,

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


Instead of requiring the user to type a '4' (or whatever), a couple of 
alternatives 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 user 
might 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 



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 
> > ures@xxxxxxxxx> To 
> Sent by: MIDRANGE-L@xxxxxxxxxxxx 
> midrange-l-bounce cc 
> s@xxxxxxxxxxxx 
> Subject 
> prob in deleting records using a 
> 05/01/2006 10:38 subfile from a pf. 
> AM 
> 
> 
> Please respond to 
> Midrange Systems 
> Technical 
> Discussion 
> > nge.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¢/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.
>
>
>
> 
>