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
To: RBASE-L Mailing List
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]] 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
To: RBASE-L Mailing List
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
( ) ( )
----------\ (----) /-----------
\__) (__/
