Nope, Unload, re-load would fail and I hate that part. The data is there, but the pointers are out of sorts.
I have a PK column for instance and it is 1 to 11855 and in the middle is missing 11202-11853 rows. BUT I can see them with RScope and rattle by the rows. So if I unload I only get 1-11201 and 11854 and 55. Keep in mind a few deletes here and there when counting up the numbers to add up to why in RBase explorer it says 11,707 and yet when you open the table you only see 11,104 and yet 1-11855 doesn't add up to either number 11,707 or 11,104. I spent 2 minutes looking at that wondering if I need more coffee. Oh it also contains a note field so Auto Fix is out also. ;( But hey, thank you for the input. Sincerely, Paul -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Alastair Burr Sent: Wednesday, June 10, 2009 4:54 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Life in RScope Paul, Without knowing your whole problem - have you tried a simple RELOAD on a COPY of the database? In my experience this sort of problem often/usually gets corrected just by a simple reload but - as always with db errors - make sure that you copy the 4 db files and use those to work on. Then, if there's further problems, you always have the "original" problem to go back to. Regards, Alastair.
