Dan, I don't recomend doing this at home. Be sure to back up your sys_forms table first, but anyway...
The driving table name for the report is stored at the beginning of the field SYS_FORM_DATA for the report where SYS_FORM_SEQ = 3 AND SYS_FORM_NAME8 = 'myform'. You could update the sys_forms table changing the table name, but there is more data in that row that you need to preserve along with the spacing. Maybee it would work best to read the row into a var, use the SRPL function and replace the table name, and then update the table. You will have to mess around with it to get the spacing correct. One more thing, the SYS_FORMS table ONLY holds the R:base for DOS forms. If you want the Windows version forms, you need to use the table SYS_FORMS2. I have never messed around with the SYS_FORMS2 table. I am not sure if you would be able to tweek it on the fly w/o corrupting it or not? Troy ===== Original Message from [EMAIL PROTECTED] at 4/08/02 4:39 pm >Thanks for the help people. > >How would you change the tableview name?? > >Dan > >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On >Behalf Of Troy Sosamon >Sent: Monday, April 08, 2002 3:21 PM >To: [EMAIL PROTECTED] >Subject: RE: COPYING FORMS AT THE R> FROM WINDOWS > > > >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 > > >-------------- Original Message >Does anybody know the command to copy a form or report from the R>?? > >I can copy from the object manager but not from the R>. > > >Dan > > > >================================================ >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/ > > >================================================ >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/ ================================================ 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/
