At 02:11 PM 6/27/2007, Steve Martin wrote:
How can I get "permission" to delete a row from sys_columns. Somehow, a
user was able to only partially remove a temporary view leaving a column
definition in the sys_columns table. I need to delete this row from the
sys_columns table but don't have adequate permission. This is true with
staticdb off and multi off.
Steve,
You mean R:BASE version 5.0/5.5 Correct?
Technically, all TEMPORARY tables should be DROPped when the database
is DISCONNected. However, re-building a fresh database should eliminate
all issues, if any.
Here's how:
DISCONNECT
SET MULTI OFF
CONNECT dbname
SET NULL -0-
OUTPUT dbname.ALL
UNLOAD ALL
OUTPUT SCREEN
DISCONNECT
RENAME dbname.RB? bkpdb.RB?
RUN dbname.ALL
DISCONNECT
SET MULTI ON
CONNECT dbname
That simple routine (even in R:BASE 5.x) will build a fresh database
while keeping everything in perspective.
Hope that helps!
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.
================================================
