At 09:08 AM 6/19/2004 -0400, Damon Kaufman 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?
Damon,
*** Using 6.5++/7.1 for DOS *** CONNECT dbname SET NULL -0-
-- Forms (one file: formname.FRM) OUTPUT formname.FRM UNLOAD DATA FOR SYS_FORMS WHERE SYS_FORM_NAME8 'formname' OUTPUT SCREEN
-- Reports (one file: reportname.RPT) OUTPUT reportname.RPT UNLOAD DATA FOR SYS_REPORTS WHERE SYS_REPORT_NAME8 'reportname' OUTPUT SCREEN
-- Labels (one file: labelname.FRM) OUTPUT labelname.LBL UNLOAD DATA FOR SYS_LABELS WHERE SYS_LABEL_NAME8 'labelname' OUTPUT SCREEN
*** Using 6.5++ for WINDOWS *** CONNECT dbname SET NULL -0-
-- Forms (two files: formname.FRM, formname.LOB) OUTPUT formname.FRM UNLOAD DATA FOR SYS_FORMS2 WHERE SYS_FORM_NAME 'formname' OUTPUT SCREEN
-- Reports (two files: reportname.RPT, reportname.LOB) OUTPUT reportname.RPT UNLOAD DATA FOR SYS_REPORTS2 WHERE SYS_REPORT_NAME 'reportname' OUTPUT SCREEN
-- Labels (two files: labelname.LBL and labelname.LOB) OUTPUT labelname.LBL UNLOAD DATA FOR SYS_LABELS2 WHERE SYS_LABEL_NAME 'labelname' OUTPUT SCREEN
*** Using 7.1 for WINDOWS *** CONNECT dbname SET NULL -0-
-- Forms (two files: formname.FRM and formname.LOB) OUTPUT formname.FRM UNLOAD DATA FOR SYS_FORMS3 WHERE SYS_FORM_NAME 'formname' OUTPUT SCREEN
-- Reports (two files: reportname.RPT and reportname.LOB) OUTPUT reportname.RPT UNLOAD DATA FOR SYS_REPORTS3 WHERE SYS_REPORT_NAME 'reportname' OUTPUT SCREEN
-- Labels (two files: labelname.LBL and labelname.LOB) OUTPUT labelname.LBL UNLOAD DATA FOR SYS_LABELS3 WHERE SYS_LABEL_NAME 'labelname' OUTPUT SCREEN
Using R:BASE 7.1 for Windows, you may also want to use the speed menu (right-click) options to download Forms/Reports and Labels.
Have fun!
Very Best R:egards,
Razzak.
--- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [EMAIL PROTECTED]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE: Send a plain text email to [EMAIL PROTECTED]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [EMAIL PROTECTED]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body, place any text to search for.
================================================
