maybe, but if you need to transfer forms, reports, and/or stored procs from
one db to another (and I do this to update my live app with my dev app info)
I have three rmds...
for Forms...
OUTPUT DBforms.all
write 'delete from SYS_FORMS3'
UNLOAD DATA FOR SYS_FORMS3
OUTPUT screen
return
------
reports...
OUTPUT DBReports.all
write 'delete from SYS_REPORTS3'
UNLOAD DATA FOR SYS_REPORTS3
OUTPUT screen
return
---
stored procs...
OUTPUT DBStorProcs.all
write 'delete from SYS_PROCEDURES'
UNLOAD DATA FOR SYS_PROCEDURES order by SYS_PROC_ID
OUTPUT screen
return
once you run these disconnect from the source db, connect to the other db,
and run the DBforms.all, DBReports.all, and DBStorProcs.all files.
----- Original Message -----
From: "Bernard Lis" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Monday, September 28, 2009 7:43 PM
Subject: [RBASE-L] - RE: Sys_comments is corrupted
Thanks Rachel,
Since I already did it the hard way, I'll keep this in mind.
But will it Fix the sys_comments table???
----- Original Message -----
From: "Rachael Malberg" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Monday, September 28, 2009 12:46 PM
Subject: [RBASE-L] - RE: Sys_comments is corrupted
here is the easy way...
1- create a rmd file with the following code...
SET VAR vCurDB TEXT =(CVAL('database'))
set var z text=('OUTPUT '+.vCurDb+'.all')
&z
UNLOAD ALL
OUTPUT SCREEN
clear var z,vCurDb
return
run the rmd, it will create two files. One named [db name].all and
another named [db name].lob. the .all file re creates the db, all the
tables, views, loads all the data and rebuilds the indexes.
2 - rename the current db.
3 - run the .all file.
----- Original Message -----
From: "Bernard Lis" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Saturday, September 26, 2009 9:31 PM
Subject: [RBASE-L] - RE: Sys_comments is corrupted
I did it the hard way --
unloaded forms and reports one by one and loaded them into the back-up
daabase. Now I'm back in business!
Bernie Lis
----- Original Message -----
From: "Bernard Lis" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Saturday, September 26, 2009 8:08 PM
Subject: [RBASE-L] - RE: Sys_comments is corrupted
Hi Paul,
Can't do that because --
R>drop table sys_comments
-ERROR- You cannot delete a system table. ( 10)
and
R>rename table sys_comments to junk nocheck
-ERROR- Reserved words cannot be used for names - sys_comments ( 57)
and:
R>del rows from sys_comments
-ERROR- Unauthorized access to the table SYS_COMMENTS for user admin
(2039)
So even if I can unload structure, what would I do with it?
Bernie Lis
----- Original Message -----
From: "Paul" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Saturday, September 26, 2009 6:35 PM
Subject: [RBASE-L] - RE: Sys_comments is corrupted
Just wondering what happens if you unload structure no data and then
reload that separate and add data after?
Of course watch your file locations. I think I did that once. Also
there
is a key seq to allow you to see all in the system tables let me
test a
couple ctrl-Alt-Tab-F8 ?? something like that
Paul
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of
Bernard Lis
Sent: Saturday, September 26, 2009 6:20 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Sys_comments is corrupted
How can I fix the sys_comments table?
I have a backup of that table in an older database.
But I can't delete or rename a system table.
Is there an easy way to fix it? I have R:scope but I'm not sure how
to fix
the sys_comments table.
Bernie Lis
--- 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.
================================================
--- 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.
================================================
