Jim: I'm curious about your comment regarding indexes. Dropping an index should be pretty much instantaneous. I have a few tables with over 4,000,000 records and dropping an index happens immediately. Creating the index takes a minute or two depending on the column being indexed.
The syntax to drop an index is: DROP INDEX <indexname> It is recommended that you give each index a unique name. The syntax for this is: CREATE INDEX <indexname> ON <TableName> (<columnname>) I typically use a naming convention that gives me an idea about the table and column being indexed. For instance: CREATE INDEX rts_seq_idx ON rej_trkg_smry (seqnum) One advantage to this is that if you need to delete the index later you can simply use the command: DROP INDEX rts_seq_idx (for instance) Check for the existence of primary keys, foreign keys and rules. R:CODE is a text editor customized for writing R:BASE programs. The new R:Base has an excellent editor integrated into it called R:BASE Editor. R:BASE Editor now has a built-in syntax checker similar to the R:Syntax checker used with R:CODE. Either one can help you find coding errors. I strongly recommend that you familiarize yourself with these tools. Since your errors seem to happen most frequently when sorting, you may need to spend the most time verifying the integrity of the database. I think Razzak outlined these for you. Hope this helps. Mike Ramsour AK Steel Coshocton Works Quality Department Phone/VMS: 740-829-4340 -----Original Message----- From: Jim Belisle [mailto:[EMAIL PROTECTED] Sent: Friday, March 14, 2008 9:43 PM To: [email protected] Subject: [RBASE-L] - Re: 7.6 crash Mike, I cleaned up most of my indexes that were on columns with many null values in the fields. I have one table that has over 76,000 records. What would be the best way to get rid of my unwanted indexes on some of the columns? I tried deleting them but it seems to take forever. I have command files called up in my applications. Is that what you are talking about below? I have not used R:CODE with the syntax checker. I did not use CODELOCK when creating my applications either. Also all my command files are quite old so I do not know about the integrity of them. I might add that the crashes do not occur when running any command files. Mostly it happens when I sort manually. I believe this will take some time for me to work out all the bugs accumulated over the last 15 years. Jim
