Thank you for the information. Mark Bailey
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Thursday, March 28, 2013 1:41 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Multi User Issue At 07:33 AM 3/28/2013, Bailey, Mark R wrote: >I ended up having to do a restore from the previous day, but you are >correct the #1 file had been corrupted. I did try to replace the #1 >file and sync the files but I got all kinds of table errors that the >number of rows were not the same and that pointers were off. > >Rbase support did suggest the RSCOPE which I am going to look into purchasing. Mark, Reverting database from the previous day was your best option; especially not knowing the technical details of R:BASE database #1 (.rb1 or .rx1) file, or not having the must have handy R:SCOPE utility. For your education ... R:BASE .RB1 (32) or .RX1 (64) database file contains the definition of the database structure, including: . Version Flag . The names of the tables and columns . The number of tables and columns . The order of tables and columns . The number and size of rows in each table . The settings for the database . Pointers Pointers link the database structure recorded in the structure file to specific, physical locations in File 2 (.RB2, .RX2), the data file. For each table in the database, the structure file contains a pointer to the start of the table and a pointer to the end of the table. R:BASE updates the information in the structure file every time the database structure is modified, rows are added or deleted, the database settings are modified, the database is disconnected, or when you exit R:BASE. R:SCOPE is a tool that lets you examine and modify R:BASE database files outside R:BASE. R:SCOPE will let you CONNect and check the database for problems and lets you look in the database files to diagnose a problem. Once you have determined the problem, R:SCOPE will also allow you to fix the structure of a database and correct data file errors. www.rbase.com/products/rscope95 Very Best R:egards, Razzak. www.rbase.com www.facebook.com/rbase
