Bill,
Which tool would I use to find out the offending views? As I stated before, I have not received this error before. Of course it would be that I neglected to UNLOAD LOAD for the last two weeks and now have to try to remember what I may have done differently. Procrastination sometimes hurts or at least takes time to undo the damage. James Belisle ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Bill Downall Sent: Friday, February 04, 2011 7:05 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Illegal table name Jim, All of the tables are reloaded before any of the views are reloaded. Most likely, you have one or more views that reference another view within the SELECT command. the UNLOAD command doesn't have a way to know that the views need to be rebuilt in any particular order. When a CREATE VIEW statement is run before a view it needs have been created, you will get exactly that error. You may need to rebuild just those views that were attempted too early in the rebuild process. Bill On Fri, Feb 4, 2011 at 7:55 AM, Jim Belisle <[email protected]> wrote: Alastair, Since my threads regarding this issue go back to 01/01/2008 and the question was sent originally by you, I will accept your answer. The main reason this concerned me was I had not gotten this message before. I use the method suggested by Razzak. I have the OUTPUT TO SCREEN while doing the reload. All the tables reload before I ever get the message. The Error message always comes at the end of the reload. Since I know nothing about the sequence of the LOAD, I just assumed the error came up at the time it occurs. James Belisle ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Alastair Burr Sent: Friday, February 04, 2011 6:42 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Illegal table name My first guess, Jim, is that your views are being reloaded before the tables they are based on have been recreated. As far as I know this is a long-standing issue that can easily be overcome by exporting all your views - or just the relevant ones if you prefer - to a file and reloading them after your main data. Either way, ignore the duplicate error messages. Regards, Alastair. From: Jim Belisle <mailto:[email protected]> Sent: Friday, February 04, 2011 11:40 AM To: RBASE-L Mailing List <mailto:[email protected]> Subject: [RBASE-L] - Illegal table name I am using the latest 7.6 version. I received the above error (5 times at end of processing the Load) when doing an UNLOAD RELOAD. I have a previous thread on this error that points to a possible problem with views. I do know I have created more tables since my previous UNLOAD RELOAD. I have looked at the new tables, including column definitions, and all looks well. No new views are based on these new tables. I did encounter an ACCESS violation when attempting to create another new table based on an Excel file. I had to use the Task Manager to get out of RBASE. What should be my next step in finding the problem? James Belisle
