It is a combination of a SEARCH action, a FOR action, and an INSERT action that will do the trick. Get the results from Table A in a search and put them into a local/request scope variable called 'l_results'. Set up a FOR action with the counter variable called 'l_counter' and the To attribute set to <@NUMROWS ARRAY='local$l_results'>.
Put the insert into the FOR action and for each of the values use <@VAR NAME='local$l_results[@@local$l_counter,x]'> where x represents the field order from the original search. Hope this helps, Steve Smith Skadt Information Solutions Office: (519) 624-4388 GTA: (416) 606-3885 Fax: (519) 624-3353 Cell: (416) 606-3885 Email: [EMAIL PROTECTED] Web: http://www.skadt.com > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Charles Brown > Sent: September 11, 2002 2:01 PM > To: Multiple recipients of list witango-talk > Subject: Witango-Talk: Adding Table A Contents to Table B > > > How do I add the contents of one table to another table? I have two > "identical" tables, each in a different data base. I need to routinely > empty Table B and add the contents of Table A to Table B (actually a > subset of the contents of Table A to Tabnle B). I think I can empty > Table B by using a selection criteria general enough in the "Delete" > action to catch all the indexed records (e.g., >=1 for the auto > increment index field should catch all the records in the Table). There > is bound to be a simple way to use the "Insert" action to add the > contents of Table A to Table B. Or not. Any suggestions will be > greatly appreciated. > > ________________________________________________________________________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body > ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
