Arev - Deleting Rows (deleted row but still exist) (AREV Specific)
At 31 MAY 2000 06:08:27PM Miel Reveche wrote:
Im trying to Delete a row.
I ran a "Select" records for an individual, and it said "5 records", I then did the List command and got only 4 record. I then decided to deleterow the 5 records. So thinking all were deleted, I ran Select again and now I have 1 record existing, I then did List and now the records does not exist (I cannot see the data).
Select the record gives me 1 row, while listing say's record does not exist.
How do I delete this phantom record(row).
Do I have a corrupted file?
At 31 MAY 2000 07:00PM Bill Titus wrote:
It is possible to create a record with a null id that will show up in a select, but not be LISTed.
Try "SELECT filename WITH @ID='"(no space - just a pair of single or double quotes). Then "EDIT filename". The edit window should contain the record, and instead of the id at the top center of the window, you'll see a small gap. Now Alt-D (delete) it.
At 31 MAY 2000 07:01PM Warren wrote:
Is the file indexed? If so, rebuild the index on the file.
The other possibility is that there is a record hashed to the wrong group. Run LHVERIFY on the file and fix with DUMP.
At 31 MAY 2000 07:02PM Warren wrote:
Is the file indexed? If so, rebuild the index on the file.
The other possibility is that there is a record hashed to the wrong group. Run LHVERIFY on the file and fix with DUMP.
At 01 JUN 2000 10:08AM Matt Sorrell wrote:
Another possibility is that there is a record that has a reserved character (char 253 - 255) in the key.
The only way I've been able to clear these out is to write an R/Basic program.
At 05 JUN 2000 06:00PM Bob Rowland wrote:
The solution that Bill describes works. This happened to me a number of years ago. It was caused by importing a bad record.
At 06 JUN 2000 06:26PM Miel Reveche wrote:
I have a record in the file "PERSONNEL" @ID=06090'
I Tried to delete a record by editing on the record ('06090') and Alt-d Alt-d. This did not delete the record. I got a Message "Deleting Associated Records in File JOB". and another message that say's "Row does not exist".
I cannot find a record associated with '06090' in the Job file.
The Personnel file '06090' has a line with data associated with the JOB file. I cannot delete this line, I blanked out the line and hit F9 to save, but the data line shows up again.
How do I deleted this Record(Row)?
At 06 JUN 2000 08:40PM Bill Titus wrote:
Miel,
It appears at least one MFS has been installed on the files in the application you are using. Contact the developer of the application for advice on how to proceed. There are undoubtedly significant reasons for not permitting the deletion of records.
Bill
At 07 JUN 2000 07:00PM Warren wrote:
Right, it sounds like there is referential integrity on these files through a MFS.
If you are normally allowed to delete records (which sounds like you are) perhaps you can just create the missing associated JOB record, then delete the PERSONNEL record.