Dear Troy; Actually, the SYS_FORMS2 and SYS_REPORTS2 tables will allow you to APPEND it to itself. However, and this was the reason for the follow-up post to my initial response, you MUST remember to UPDATE the row that you just inserted so that there are not duplicate forms or reports.
By using the WHERE COUNT = INSERT clause, you target the last row that you, yourself, inserted. Have a good one. Mike At 04:21 PM 4/8/2002 -0600, you wrote: >You could do it something like this: > >R> project temp_form from sys_forms using all where sys_form_name8 = >'myform' >R> update temp_form set sys_form_name8 = 'newform' >R> append temp_form to sys_forms > >I am assuming that R:base will let you get away with the initial project >that will have columns that are reserved names. If that doesn't work, you >will have jump through some hoops giving your temp table different col names >and then inser into the temp table, update it, and then insert back into the >sys_forms tabele. > >Troy ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
