Also, make sure you SET NULL -0- before unloading the data. If you have it set to ' ' your reports and forms will be unusable in the new database.
[EMAIL PROTECTED] wrote: >In a message dated 4/25/2002 9:25:27 AM Eastern Daylight Time, >[EMAIL PROTECTED] writes: > ><< I have heard several ways of taking reports and forms out of > one database and using/importing them in another. � > > I was trying to find the approved standard (for lack of a better set of > words). � > >> >Phil, >I don;t know if it is the APPROVED way, but I have a cludge that works <g> >Connect to the old database >Output filename >Unload the data SYS_Forms or Sys_Forms2 table as is appropriate >R: unload data for sys_forms2 where SYS_FORM_Name = 'FormName' >output screen >connect to the new database >load SYS_Forms or SYS_Forms2 from Filename >Then do the same thing for reports >Report tables are SYS_Reports and SYS_Reports2 >DON'T try to mix the sys_forms and the sys_forms2 >The 2 at the end of the name signifies the Windows version. >If you're copying to another directory, be sure to take the .LOB file with >it, or it won't work in windows. I'm not sure if the lob file is strictly for >forms, and reports uses another extension or not. >However, before I did ANYTHING, I would make a backup so you can play and be >sure it works OK. >Not that I would EVER louse up my databases by playing, and need to restore >that copy <g> > >Damon > >Damon D. Kaufman >President >Stalder Spring Works, Inc >ISO-9002 / QS-9000 Certified >2345 S. Yellow Springs St. >Springfield, Ohio 45506 >Voice 937-322-6120 >Fax 937-322-2126 >email: [EMAIL PROTECTED] >================================================ >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/ > __________________________________________________________________ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.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/
