Bruce Maybe I missed something but I don't see where you are creating an index. That is why when you "List INDEX" nothing is found. If you want to see your PK and FK do "LIST CONSTRAINT"
Buddy -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Bruce Chitiea Sent: Thursday, October 07, 2010 11:30 AM To: RBASE-L Mailing List Subject: [RBASE-L] - AutoChk / Index Error All: PROBLEM When run AUTOCHK, get error message: '-ERROR- Error reading the index list. (1222)' SETUP 1) Create a new database; 2) Create and link a handful of core and lookup tables with PKs, FKs but no non-key indexes or UKeys; 3) Enter data and prove relational integrity ok; 4) Decide I really hate my table/column naming; 5) Delete FKs and rename all tables and all columns ok; 6) Verify PKs for each table ok; 7) Recreate FKs and prove relational integrity ok; 8) Run PACK ok; run RELOAD for clean copy ok; 9) Run AUTOCHK on clean copy, get error message. 10) Run LIST INDEX; advised "There are no user defined indexes (2746)". Where/how might I look for the problem? bruce chitiea safesectors inc. v8.0.23.30809 SU --- RBASE-L =======================3D======================= D= 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) =======================3D======================= D= TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO =======================3D======================= D= TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE =======================3D======================= D= 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. =======================3D======================= D=
