Hate to ask this but I've pretty much figured out that I need to use a scrolling region in one particular instance. I haven't worked with scrolling regions in years.
Is there a limit to how many rows can be displayed? Can we force going to a specific row? Jan -----Original Message----- From: "A. Razzak Memon" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Fri, 07 Dec 2012 16:43:13 -0500 Subject: [RBASE-L] - Re: old rb files At 04:26 PM 12/7/2012, Dan Goldberg wrote: >I am needing to get data from a backup 7.6 32 bit rbase >files(rb1-rb2-rb3-rb4). I am now using 9.5 64 bit. > >I cannot open it with 9.5 and do not have 7.6 license anymore. How >do I open a old database and get data from it? Dan, You can use your existing version of R:BASE eXtreme 9.5 (64) to convert R:BASE 7.6 database. Use the TURBO command to convert the database. Here's how: If there is no OWNER 01. Launch R:BASE eXtreme 9.5 (64) 02. Navigate to your database directory using the "Change Current Folder" button (bottom left corner, folder icon with a green arrow) 03. Go to the R> Prompt window (third button from the left on the Tool Bar, or press [Ctrl]+[R]) 04. At the R> Prompt, type: SET MULTI OFF , then press [Enter] 05. At the R> Prompt, type: SET STATICDB OFF , then press [Enter] 06. At the R> Prompt, type: TURBO DBNAME , then press [Enter] 07. At the R> Prompt, type: CONNECT DBNAME , then press [Enter] If there is an Owner 01. Launch R:BASE eXtreme 9.5 (64) 02. Navigate to your database directory using the "Change Current Folder" button (bottom left corner, folder icon with a green arrow) 03. Go to the R> Prompt window (third button from the left on the Tool Bar, or press [Ctrl]+[R]) 04. At the R> Prompt, type: SET MULTI OFF , then press [Enter] 05. At the R> Prompt, type: SET STATICDB OFF , then press [Enter] 06. At the R> Prompt, type: TURBO DBNAME IDENTIFIED BY ownername , then press [Enter] 07. At the R> Prompt, type: CONNECT DBNAME , then press [Enter] Complete Database Rebuild In addition to the above conversion steps, the following steps are required to completely rebuild the database. These steps will be performed in R:BASE eXtreme. 01. Connect to the database and open the R> Prompt. 02. Check the IDQUOTE settings of connected database. At the R> Prompt, type: SHOW CHARACTERS Notice the last parameter, IDQUOTES If IDQUOTES is set to NULL, you'll need to change NULL to the appropriate character, such as ` (reversed quote) as following: SET IDQUOTES= ` 03. Unload the entire database. Use the SET USER command below if an OWNER name exists. At the R> Prompt, type: SET NULL -0- SET USER ownername OUTPUT filename.ALL UNLOAD ALL OUTPUT SCREEN This process will create two files (filename.ALL and filename.LOB) 04. Disconnect the database. At the R> Prompt, type: DISCONNECT 05. Now rename the database that was just unloaded in Steps 1-3. Review the list of Databases in the R:BASE eXtreme Database Explorer, and select the "Rename" option. Enter a new name for the database. 06. Finally, use R:BASE to rebuild the database by running the .ALL file. At the R:BASE eXtreme R> Prompt type: RUN filename.ALL These steps will build a clean database! That's all there is to it! Very Best R:egards, Razzak. www.rbase.com www.facebook.com/rbase
