6.5 does not have a ......3 tables. Those definitions are not compatible with 7.6 & 8.0 Converting in 7.6 creates the ....3 defintions
________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Rachael Malberg Sent: Thursday, March 26, 2009 10:33 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: 6.5++ Copying a Report from one DB to another true but the question was, using 6.5 why does the following syntax not work... OUT REP.TXT UNLOAD DATA FOR SYS_REPORTS2 WHERE SYS_REPORT_NAME = ' OVERUNDERREPORT ' OUT SCR and what I was trying to say is in 8.0, I unload reports from the SYS_REPORTS3 table not the SYS_REPORTS2 table but wasn't certain if that would be true for 6.5, I'm sure there is someone out there that can fill me in. (MikeB, Emmitt, Karen??) Oh and Damon, I once got tripped up and 'thought' there was no LOB file too but I was looking for it using R:BASE Explorer under Command Files and didn't 'see' any. Well when I opened Win Explorer, I saw it was actually there. Turns out my 'File Mask' had the default "*.DAT;*.RMD;*.CMD;*.APP;*.EEP;*.VIE;" but no "*.LOB;" so I couldn't see my LOB files. added it, hit apply, and whalla! there it was. another thing your sample criteria has spaces '{space}OVERUNDERREPORT{space}' not sure if this a true in your live code but if it is this will affect your return... well those are the only ideas I've got. GOOD LUCK!! ----- Original Message ----- From: Dennis McGrath<mailto:[email protected]> To: RBASE-L Mailing List<mailto:[email protected]> Sent: Thursday, March 26, 2009 9:38 AM Subject: [RBASE-L] - Re: 6.5++ Copying a Report from one DB to another You cannot export import forms/reports/labels directly from 6.5 to 8.0 You need to convert the forms using 7.6 and then you can export them to 8.0 Dennis McGrath ________________________________ From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Rachael Malberg Sent: Thursday, March 26, 2009 9:34 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: 6.5++ Copying a Report from one DB to another not sure if 6.5 is like 8.0 but 8.0 reports are in SYS_REPORTS3 table. ----- Original Message ----- From: Gray, Damon<mailto:[email protected]> To: RBASE-L Mailing List<mailto:[email protected]> Sent: Wednesday, March 25, 2009 9:15 AM Subject: [RBASE-L] - 6.5++ Copying a Report from one DB to another As I understand it, this should allow me to copy a report from DB1 to DB2 SET IDQUOTES = ` SET NULL -0- Then, OUT REP.TXT UNLOAD DATA FOR SYS_REPORTS2 WHERE SYS_REPORT_NAME = ' OVERUNDERREPORT ' OUT SCR At this point, there are supposed to be two files in my DB1 folder, REP.TXT and REP.LOB There is no LOB file. Am I missing a step? wwwww ( @ @ ) -------oOO---(_)---OOo------- Damon J. Gray Anvil Corporation Business Services (360) 937-0770 oooo0 0oooo ( ) ( ) ----------\ (----) /----------- \__) (__/
