Forms 3.0 Selecting multiple records into a block? Not Querying...

[Quoted] [Quoted] [Quoted] 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 [Quoted] want to destroy queried records with user commited updates. I plan to select records into 3 multiple record blocks from three tables then [Quoted] insert the selected/user updated records into another 3 identical tables. This [Quoted] is to preserve the original tables data for future use. Since a [Quoted] 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 reply.(Hehe) Thanks Mark...   Received on Tue May 13 1997 - 00:00:00 CEST