Re: Forms 3.0 Selecting multiple records..(I figured it out.. Dont bother..)

From: Mark S Reichman <reichmanm_at_rl.af.mil>
Date: 1997/05/13
Message-ID: <5la56n$13t_at_news.rl.af.mil>#1/1


[Quoted] I figured this out... Please dont waste anytime on this.. Thanks...

In article <5l9rdm$g6_at_news.rl.af.mil>, reichmanm_at_rl.af.mil says...
>
>Otay...
>
> Yes we still use forms 3.0 and do not use froms 4.5. We are however
>converting to Designer/Developer 2000 progs soon. So... That aside..
>My question..
>
>I need to select multiple records into a block. Up to this point I have
>never had to do this. I do not want to query the records because I do not
>want to destroy queried records with user commited updates.
>I plan to select records into 3 multiple record blocks from three tables then
>insert the selected/user updated records into another 3 identical tables.
 This
>is to preserve the original tables data for future use. Since a
>TOO_MANY_ROWS exception will occur in the select statement when multiple
>records are returned, placing "null;" in the exception handler for
>TOO_MANY_ROWS will only allow the display of the first record selected by the
>select statement. I need all the records selected to show up in the block.
>Formatting the form to display multiple records is not a problem, making
>the a select statement return more that one record into a multi record
>block is the entire problem.
>
>Any suggestion? If this is possible you may use the word "Idiot" in your [Quoted]
>reply.(Hehe) Thanks Mark...
>
>
Received on Tue May 13 1997 - 00:00:00 CEST

Original text of this message