Great info! Thanks Razzak!
"The other reason" is consistent with the settings during the work week
(STATIC ON, FASTLOCK ON) and structure updates I was doing over the
weekend with STATIC OFF via remote support; it likely was interrupted.
I had RELOADed the db when I was done, but UNLOAD and INPUT finally
fixed it.
Thanks also for Choosing the Ideal DB Grid Control TOTD. It's a very
succinct, useful summary for the new X.5 controls.
Doug
On 10/15/2019 8:45 AM, A. Razzak Memon wrote:
Doug,
There appears to have been an interruption during the table structure
updates.
Normally, the warning icon upon the database cylinder at the Database
Explorer signifies the file version is not of 10.0 or 10.5, and is a
.RB1-.RX4 database at version 9.5 or below. Since you are able to
connect to the database with 10.5, that is not the case.
The other reason for the warning icon upon the database cylinder at
the Database Explorer would be the version flag is set to some other
value than -1101, which is the normal mode version flag when you
disconnect a database or exit R:BASE normally. The version flag for
10.5 can range from -1101 to -1136 based upon variations of database
settings in place; including STATICDB, TRANSACT, COMPATIB, FASTFK, and
FASTLOCK. The settings in place can be reviewed using the SHOW command
at the R>.
To see the version flag, connect to the database with R:Scope, and
select the Check > Database Info menu options. R:Scope can also be
used to correct the version flag.
-1101
Normal mode version flag is set to -1001 when you disconnect a
database or exit R:BASE normally.
-1102
Database is in read-only schema mode (STATICDB setting is on).
-1103
Database is in transaction processing (TRANSACT is set on).
-1104
Database is in transaction processing mode and is in need of recovery.
Use the RECOVER command to restore the database.
-1105
Database is in transaction processing with compatibility (TRANSACT and
COMPATIB is set on).
-1106
Database is in transaction processing mode with compatibility and is
in need of recovery. Use the RECOVER command to restore the database.
-1111
Normal mode with FASTFK on.
-1112
Read-only schema (STATICDB on) with FASTFK.
-1113
Database is in transaction processing with FASTFK.
-1114
Database is in transaction processing mode with FASTFK and is in need
of recovery. Use the RECOVER command to restore the database.
-1115
Database is in transaction processing with compatibility and fast FK
(TRANSACT, COMPATIB, and FASTFK is set on).
-1116
Database is in transaction processing mode with compatibility and fast
FK, and is in need of recovery. Use the RECOVER command to restore the
database.
-1121
Normal mode with FASTLOCK on.
-1122
STATICDB on with FASTLOCK.
-1123
Database is in transaction processing with FASTLOCK.
-1124
Database is in transaction processing mode with FASTLOCK and is in
need of recovery. Use the RECOVER command to restore the database.
-1125
Database is in transaction processing with compatibility and FASTLOCK
(TRANSACT, COMPATIB, and FASTLOCK is set on).
-1126
Database is in transaction processing mode with compatibility and
FASTLOCK, and is in need of recovery. Use the RECOVER command to
restore the database.
-1131
Normal mode with FASTFK and FASTLOCK on.
-1132
STATICDB is on with FASTFK and FASTLOCK.
-1133
Database is in transaction processing with FASTFK and FASTLOCK.
-1134
Database is in transaction processing mode with FASTFK and FASTLOCK
and is in need of recovery. Use the RECOVER command to restore the
database.
-1135
Database is in transaction processing with compatibility, fast FK, and
FASTLOCK (TRANSACT, COMPATIB, FASTFK, and FASTLOCK is set on).
-1136
Database is in transaction processing mode with compatibility, fast
FK, and FASTLOCK, and is in need of recovery. Use the RECOVER command
to restore the database.
R:Scope Product Details:
https://www.rbase.com/products/rscope/
Very Best R:egards,
Razzak.
https://www.rbase.com
http://www.facebook.com/rbase/
At 03:14 PM 10/14/2019, Doug Hamilton wrote:
Unload & Input seemed to fix it. (BTW, this is version X.5 E)
Questions still remain:
What does the yellow exclamation point in front of a db in name in DB
Explorer mean?
Is there a column length limitation in computed columns?
Tnx,
Doug
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/3ae59496-d060-6443-082e-721ffe0c270f%40wi.rr.com.
