Thanks Buddy,I will try you idea. As far as a structural change this happened
on a compiled version.Tom Hart
On Wednesday, June 10, 2015 5:08 PM, Buddy Walker
<[email protected]> wrote:
<!--#yiv7810866540 _filtered #yiv7810866540 {font-family:Helvetica;panose-1:2
11 6 4 2 2 2 2 2 4;} _filtered #yiv7810866540 {font-family:Helvetica;panose-1:2
11 6 4 2 2 2 2 2 4;} _filtered #yiv7810866540 {font-family:Calibri;panose-1:2
15 5 2 2 2 4 3 2 4;} _filtered #yiv7810866540 {font-family:Tahoma;panose-1:2 11
6 4 3 5 4 4 2 4;}#yiv7810866540 #yiv7810866540 p.yiv7810866540MsoNormal,
#yiv7810866540 li.yiv7810866540MsoNormal, #yiv7810866540
div.yiv7810866540MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New
Roman", "serif";}#yiv7810866540 a:link, #yiv7810866540
span.yiv7810866540MsoHyperlink
{color:blue;text-decoration:underline;}#yiv7810866540 a:visited, #yiv7810866540
span.yiv7810866540MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}#yiv7810866540
span.yiv7810866540EmailStyle17 {font-family:"Calibri",
"sans-serif";color:#1F497D;}#yiv7810866540 .yiv7810866540MsoChpDefault
{font-size:10.0pt;} _filtered #yiv7810866540 {margin:1.0in 1.0in 1.0in
1.0in;}#yiv7810866540 div.yiv7810866540WordSection1 {}-->Tom I’ve seen this
happen when someone is trying to make a structure change while there are users
in the database. It also has happened for reasons unknown. What I have done
in the past was to get the RB1 (one I know wasn’t a problem) copy it to the
current database. You will then have to RBSYNC. Next run a reload you get a lot
of errors with the counts not matching. After that unload the database
structure and data. Recreate the database from the unload. One thing you
might want to try is R:Scope before trying anything else. I guess it goes
without saying make a copy of the database before doing anything. Buddy
From: [email protected] [mailto:[email protected]] On Behalf Of TOM HART
Sent: Tuesday, June 09, 2015 10:36 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Strange sys_table I had posted about the corrupt database
which is giving my fits, what I have found out is that a temp table shows up as
a sys_table as follows(the highlighted is the temp table)
SYS_TABLE_QUAL SYS_TABLE_OWNER SYS_TABLE_NAME SYS_TABLE_TYPE
SYS_COMMENT SYS_SCHEMA_NAME SYS_TABLE_ID SYS_NUM_COLUMNS
SYS_NUM_ROWS SYS_ROW_SIZE SYS_TEMPORARY
NONE SYS_COMMENTS SYSTEM TABLE temp1 1 2 238 4104
NONE SYS_DEFAULTS SYSTEM TABLE temp1 2 4 8 80
NONE SYS_RULES SYSTEM TABLE temp1 3 6 4 4120
NONE SYS_VIEWS SYSTEM TABLE temp1 4 3 2 4108
NONE SYS_CONSTRAINTS SYSTEM TABLE temp1 7 7 30
4124
NONE SYS_TABLES SYSTEM TABLE temp1 8 11 -4 4200
NONE SYS_COLUMNS SYSTEM TABLE temp1 9 14 -4 4170
NONE SYS_INDEXES SYSTEM TABLE temp1 10 24 -4 138
NONE SYS_FORMS SYSTEM TABLE temp1 11 3 92
NONE SYS_REPORTS SYSTEM TABLE temp1 12 3 92
NONE SYS_LABELS SYSTEM TABLE temp1 13 3 92
NONE SYS_LAYOUTS SYSTEM TABLE temp1 14 2 4138
NONE SYS_TYPES SYSTEM TABLE temp1 15 14 -4 4170
NONE SYS_FORMS2 SYSTEM TABLE temp1 16 4 4152
NONE tomtinventorytab SYSTEM TABLE inventory table temp1 17
23 -16 274
NONE SYS_LABELS2 SYSTEM TABLE temp1 18 4 4152
NONE SYS_SERVERS SYSTEM TABLE temp1 19 4 4112
NONE SYS_PROCEDURES SYSTEM TABLE temp1 20 10 4164
NONE SYS_PROC_MODS SYSTEM TABLE temp1 21 8 4156
NONE SYS_PROC_COLS SYSTEM TABLE temp1 22 10 4136
NONE SYS_TRIGGERS SYSTEM TABLE temp1 23 4 16
NONE SYS_FORMS3 SYSTEM TABLE temp1 24 5 130 4168
NONE SYS_REPORTS3 SYSTEM TABLE temp1 25 5 52 4168
NONE SYS_LABELS3 SYSTEM TABLE temp1 26 5 7 4168
NONE SYS_MERGE SYSTEM TABLE temp1 27 6 4172
NONE SYS_LAYOUTS3 SYSTEM TABLE temp1 28 3 4154
What happened? If I do a reload it is still there. I also have tried
unloading but Rbase crashes. Any help Tom Hart
