You should use the DirectDBMS Action And do directDBMS1 = "Delete from TableB" directDBMS2 = "insert into TableB select * from TableA"
The Insert Action is for a single row of data and looping inserts is very inefficient Ben Johansen - http://www.pcforge.com Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm Latest downloads & List Archives @ http://www.witango.ws -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Charles Brown Sent: Wednesday, September 11, 2002 11:01 AM 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
