Our main databases run with STATICDB ON and I see no "!". Regards,
Stephen Markson The Pharmacy Examining Board of Canada 416.979.2431 x251 -----Original Message----- From: [email protected] <[email protected]> On Behalf Of Dan Goldberg Sent: October 15, 2019 11:13 AM To: [email protected] Subject: RE: [RBASE-L] - ! in front of db name Staticdb setting will show as an ! Dan Goldberg -----Original Message----- From: [email protected] <[email protected]> On Behalf Of Doug Hamilton Sent: Tuesday, October 15, 2019 8:12 AM To: [email protected] Subject: Re: [RBASE-L] - ! in front of db name 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://linkprotect.cudasvc.com/url?a=https%3a%2f%2fwww.rbase.com%2fpr > oducts%2frscope%2f&c=E,1,q9MfsqKLm1l1qTV5PLdTWn_LjwbcLDVYSWpnPcmalPzBJ > Bh-cbWKHGMFgRenDKZrClm9NFi2T6RDSwKgxEwCtNCeQcpBPynkRW4dZwKlCDu-BkXOIi1 > _qgIH&typo=1 > > Very Best R:egards, > > Razzak. > > https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fwww.rbase.com&c=E, > 1,0FKQW9xAjTQhxi6sS66wVQvCo5lAaSproQT87U2boIHHUP3TlYICuHPiaMsaDxFwtPx_ > JfpA1Q-Mctgsf4xeN6mR2ESY9C1dLawlR8BN1398&typo=1 > 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 https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fwww.rbase.com%2fsupport%2fusersgroup_guidelines.php&c=E,1,QSkpOCNNkAD9ELzLc3RU_8leTFOhobmvJlyruU6f4eYycK5OAX_ydcdciPYcJMtmOGs90Ok_575HAVJSBU99Rpm2Mw_Qu2TUX-pZ-16nvMfZOPyVAWPHmZg,&typo=1 --- 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://linkprotect.cudasvc.com/url?a=https%3a%2f%2fgroups.google.com%2fd%2fmsgid%2frbase-l%2f3ae59496-d060-6443-082e-721ffe0c270f%40wi.rr.com.&c=E,1,LFgipqfk4IuEPNDNd3iVEaDl9BowPNPh1tn7oxs74x2wW6NODAZXqEC0ZzGYdrRZvPTXpShNDxKZBIzX8oyZFuvObAp2offHyHxYkQ52MzK1&typo=1 -- For group guidelines, visit https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fwww.rbase.com%2fsupport%2fusersgroup_guidelines.php&c=E,1,XBmlxDFGma3DE4UgjiyJeQ7-XbIbjMf4GYeDQxNzFxlxMD4dJorHAIFOvoxQM5T54zhPZfhX2cscg0ArLjc8AZx-pVhj5T07KaQ-cFqI1CIM_ONM_Pxw&typo=1 --- 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://linkprotect.cudasvc.com/url?a=https%3a%2f%2fgroups.google.com%2fd%2fmsgid%2frbase-l%2f2E4830CEC16615458329D3D83342F8D0011EBBE7D0%40EXCHANGE10.&c=E,1,10ffqsmuaQ8I4keV3VcG-aafpgwDetfJIeml04cfy31KQ0Co3vRyZppUS550ir9dFjeRAI54ksP8vFXiOrVv02VD5aXbgRQKUskDwh4FRpVzfmLNB_X4t0nBGks,&typo=1 -- 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/QB1PR01MB2978AC2674C959B7A5F72CCBD6930%40QB1PR01MB2978.CANPRD01.PROD.OUTLOOK.COM.
