Thanks everyone for your great suggestions. I solved the problem. For some reason, Mike Byerley's idea suggested to me that I should change my null setting. I changed null to ^ then typed SET^BLANK=' ' at the R>. Next, I changed null back to -0- and walla, I'm back in business.
I owe a great debt to all of you. It was so great to get so many suggestions and an answer. You all are great. Keep up the good work. Maybe I'll get as good as you all and come up with a solution some day. I know I'll enjoy doing R:BASE anyway. Thanks again, Phillip Cecil ________________________________ From: MikeB <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Wednesday, March 11, 2009 4:22:11 PM Subject: [RBASE-L] - Re: Setting Blank special character I don't think you can get around it because the buffer in the R> treats the null as the end of the string. I tested this by creating a string in my text editor as follows: set[insert the null char here]blank='^' When cut and pasted into the R> all that is copied to the buffer is: set So if the Null is the EOL, me thinks you're hosed unless you send the db to RBTI and they can unscramble the db setting. ----- Original Message ----- From: "Alastair Burr" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Wednesday, March 11, 2009 4:25 PM Subject: [RBASE-L] - Re: Setting Blank special character Okay, that makes me think that something else may have been re-set. Single word commands should still work because no set characters are involved so if you type at the R:> SHOW[Enter] (with no space) do you get the list of characters: Blank Delimit , LineEnd ^ Semi ; Quotes ' Plus + Single _ Many % IDQuotes ` If you put the cursor on the word BLANK and then press [End] does the cursor move in line with the other displayed characters? Are the other characters correct - they might not match mine - but if you have Quotes wrong you could be getting a problem The other thing is that the Help offers: SET BLANK=NULL SET BLANK=^ where the ^ represents a space. This seems to be something of a contradiction since once the blank is "nothing" the following command should have nothing separating the words in that command. Again, you might try variations and see what happens. Regards, Alastair. ----- Original Message ----- From: Phillip or Anna Cecil To: RBASE-L Mailing List Sent: Wednesday, March 11, 2009 5:40 PM Subject: [RBASE-L] - Re: Setting Blank special character Alastair, Thanks for your suggestions but they all give me the same error "-ERROR-Unrecognized command - retype it ( 40)." ------------------------------------------------------------------------------ From: Alastair Burr <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Wednesday, March 11, 2009 3:16:11 AM Subject: [RBASE-L] - Re: Setting Blank special character I'm not sure if anybody else has suggested this but have you tried at the R:> SETBLANK=' '[Enter Key] That is the command with no spaces in it at all except for one space between the quotes. (Use double quotes if that's your quote setting.) There are also variations that you can try: SETBLANK^[Enter Key] or SETBLANK=^[Enter Key] where the ^ represents a space. Less likely to work but might be worth a try if nothing else works is: SET-0-BLANK-0-=-0-' '[Enter Key] In other words, the null representation where you would normally have a space. Also try the two above variations in this format. Good luck, Regards, Alastair. ----- Original Message ----- From: Phillip or Anna Cecil To: RBASE-L Mailing List Sent: Wednesday, March 11, 2009 2:12 AM Subject: [RBASE-L] - Re: Setting Blank special character Bill, Dennis and Razzak, Thank you very much for your suggestions. Unfortunately, we went from RBDOS 4.5 to RBWIN 6.x so we don't have RBDOS 6.5 to try. I have my original RBENGINE76.CFG which has BLANK set to a space but that appears to get overridden by the database setting in the case where someone set BLANK to NULL. Hopefully, we have a recent backup that we can restore from. I will have to either keep users from getting to the R> or try to impress on them not to set BLANK to NULL since there does not seem to be a way to undo that setting. Maybe I can convince my client to get Rscope. Thanks again, for all your help and for helping all of us with our issues, Phillip Cecil ---------------------------------------------------------------------------- From: Dennis McGrath <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Tuesday, March 10, 2009 3:49:18 PM Subject: [RBASE-L] - Re: Setting Blank special character That is what I found too. Once BLANK was set to NULL there was no way to change it in RBWIN, only in RBDOS. This seems to be a legacy problem, as it has been that way for some time. IN RBDOS the changes you make using SET affect not only the environment but the db too. You have to deliberately move to save to change setting in the CFG. IN RBWIN the changes you make do not seem to get saved in the db, instead it wants to save them to the CFG file. Always answer NO unless you want your CFG file corrupted. I keep carefully crafted copies of all my configs on a network drive so if I mess up, I can copy the good one down from the server and just change the internal NAME line. RULE OF THUMB – never change your blank setting for any reason whatsoever. Dennis McGrath ---------------------------------------------------------------------------- From: [email protected] [mailto: [email protected] ] On Behalf Of Bill Downall Sent: Tuesday, March 10, 2009 3:23 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Setting Blank special character Philip, Another possibility is: do you still have R:BASE for DOS 6.5 or later? If so, you should be able to connect to a 7.6 database with that from the menus. press [esc] if you are at a DOS R> prompt. Use the Databases menu to navigate to the folder with the database. select the database. Go to Tools/Settings Go to Characters/Blank type your single space in the "Set to" box. [Esc] until you leave R:BASE for DOS Your change should have now been saved with the database. As long as the new RBENGINE76.CFG file is correct already, you should be good to go from 7.6 Windows. Bill On Tue, Mar 10, 2009 at 4:05 PM, Phillip or Anna Cecil <[email protected]> wrote: Thanks, Razzak, but, unfortunately, when I click OK as instructed at the end of step 07, I got the same error "-ERROR- Unrecognized command - retype it ( 40)". Is Rscope the only other option? Thanks, Phillip Cecil ---------------------------------------------------------------------------- From: A. Razzak Memon <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Monday, March 9, 2009 11:39:56 PM Subject: [RBASE-L] - Re: Setting Blank special character At 11:00 PM 3/9/2009, Phillip or Anna Cecil wrote: > The next time I started R:BASE, I got the following error > "Invalid RBENGINE76.CFG command: MENU BLACK ON GRAY" then > I got the the orginal error "Unrecognized command - retype > it ( 40)". I restored RBENGINE76.CFG from backup so I'm > fine as long as I don't open the database with the issue. > Any other ideas? Phillip, Got R:Scope 7.6? If not, follow steps below to create a fresh RBENGINE76.CFG file and then fix the BLANK setting for the database in question: 01. Using Windows Search option, look for RBENGINE76.CFG file. Rename or delete all RBENGINE76.CFG files. 02. Start R:BASE 7.6 for Windows A fresh RBENGINE76.CFG will be created in the "Start in" folder as defined in R:BASE 7.6 shortcut properties. 03. Exit R:BASE 7.6 for Windows 04. Now move the freshly created RBENGINE76.CFG file to \Windows folder 05. Start R:BASE 7.6 for Windows 06. CONNect the database in question using the DB Explorer 07. Type SET at the R> prompt and change the setting for BLANK to space (by pressing once on the space bar) Click on the [OK] button to save Configuration Settings. Figure 1: http://www.rbase.com/rbg76/settings/CharacterSettings.png 08. Alternatively, use R:Scope 7.6 to handle the situation like yours and more ... as illustrated in Figure 2: Figure 2: http://www.rbase.com/rbg76/settings/RScope76.png 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. ================================================ ---------------------------------------------------------------------------- No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.0.237 / Virus Database: 270.11.9/1993 - Release Date: 03/10/09 07:19:00 ------------------------------------------------------------------------------ No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.0.237 / Virus Database: 270.11.10/1994 - Release Date: 03/10/09 19:51:00
