Here is what I do
--MaintForms.MEN
COLUMN |-Please Select-|
|Unload Form|
|Unload Report|
|Load Form|
|Load Report|
|Close|
ENDC
--MaintForms.RMD
CHOOSE vAz FROM MaintForms.MEN AT 10,20
SET VAR vFormName TEXT = NULL
SET VAR vReportName TEXT = NULL
SET VAR vFormFileName TEXT = NULL
SET VAR vReportFileName TEXT = NULL
--Unload Form
IF vAz = 1 THEN
CHOOSE vFormName FROM #FORMS AT 10,20
SET VAR vFormFileName = .vFormName + '.FRM'
SET QUOTES="
SET VAR vFormName =("'"+.vFormName+"'")
SET QUOTES='
OUTPUT .vFormFileName
BACKUP DATA FOR SYS_Forms2 WHERE SYS_FORM_NAME = &vFormName
OUTPUT term
GOTO DONE
ENDIF
--Unload Report
IF vAz = 2 THEN
CHOOSE vReportName FROM #REPORTS AT 10,20
SET VAR vReportFileName = .vReportName + '.RPT'
SET QUOTES="
SET VAR vReportName =("'"+.vReportName+"'")
SET QUOTES='
OUTPUT .vReportFileName
BACKUP DATA FOR SYS_Reports2 WHERE SYS_REPORT_NAME = &vReportName
OUTPUT Screen
GOTO DONE
ENDIF
--Load Form
IF vAz = 3 THEN
CHOOSE vFormName FROM #FORMS AT 10,20
DROP FORM .vFormName
SET VAR vFormFileName = .vFormName + '.FRM'
RUN &vFormFileName
GOTO DONE
ENDIF
--Load Report
IF vAz = 4 THEN
CHOOSE vReportName FROM #REPORTS AT 10,20
DROP REPORT .vReportName
SET VAR vReportFileName = .vReportName + '.RPT'
RUN &vReportFileName
GOTO DONE
ENDIF
--Close
IF vAz = 5 THEN
GOTO DONE
ENDIF
LABEL DONE
CLEAR VAR vAZ, vFormName, vReportName, vFormFileName, vReportFileName
On 19 Jun 2004 at 9:08, [EMAIL PROTECTED] wrote:
> Can some one please refresh me on what the command line is to unload a form
> or report to a file, so it can be transferred to another database, or backed up
> individually?
>
> TIA,
>
> 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]
>
Victor Timmons
Tiz's Door Sales, Inc
425-258-2391
